The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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