| 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!
