Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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% |
Solved! Go to Solution.
So I figured it out.
I created a new measure
So I figured it out.
I created a new measure
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |