Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
77 | |
76 | |
44 | |
30 | |
26 |
User | Count |
---|---|
97 | |
91 | |
52 | |
47 | |
46 |