How to SUM DISTINCT Values in a column based on a unique count in another column of a Power BI table

23 Views Asked by At
Employee Claim Amount
James 50
James 20
James 10
Alex 30
Alex 20

I have a table above which I would like to calculate the sum of the claim amount divide by the unique count of employee which is 2 to achieve 65 in PowerBI.

Appreciate if help could be provided with the DAX formula, thank you!

1

There are 1 best solutions below

1
davidebacci On BEST ANSWER
Measure = DIVIDE(SUM('Table'[Claim Amount]),  DISTINCTCOUNT('Table'[Employee]))

enter image description here