Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |