Forum Discussion
Solved
Need help with Calculating a % from a table with duplicates
Need help to understand why this calulation is not working as expected. The measure I'm using is below. It's close but not perfect. % of Assets is not calulating the percentage correctly and I've added the Expected Percentage column to show what I would expect to see. The table / column I'm using (address) does contain duplicates. I tried a formula with Distinct and it didn't seem to work as well. I think I'm just looking for a calculation that does a distinct.
Measure
% of Assets = COUNTA('Table'[Address])/CALCULATE(COUNTA('Table'[Address]),ALLSELECTED())
| Status | Count of Address | % of Assets | Expected Percentage |
| Assets Successfully Measured | 3136 | 97.1138% | 94.94% |
| Assets Unsuccessfully Measured | 85 | 2.4655% | 2.57% |
| Offline | 18 | 0.1541% | 0.54% |
| Processing | 64 | 0.2665% | 1.94% |
| Totals | 3303 | 99.9999% | 100.00% |
So I figured it out.
I created a new measure
% Unique Assets = DISTINCTCOUNT('Table'[Address])and changed the value to show value as Percent of grand total.
1 Reply
So I figured it out.
I created a new measure
% Unique Assets = DISTINCTCOUNT('Table'[Address])and changed the value to show value as Percent of grand total.