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!