Forum Discussion
Counts giving wrong results in PowerBI
Hi All,
I have an issue to count the coulmn values ("Count of APIDisplayName"). Both PowerBI Chart and Table giving me wrong counts. Added my issue in snap for better understand. Red coloured lines having an issue in wrong count. Blue coloured lines are giving correct count.
How to correct this Total and Distinct Count to actual result? which is 93 not 79.
Please help on this.
Refrenced couple of blogs like https://community.powerbi.com/t5/Desktop/COUNT-function-giving-strange-results/m-p/545644#M256452, didn't find satisfied answers.
=SUMX(VALUES(Table[Product Display Name]),CALCULATE(DISTINCTCOUNT(Table[APIDisplayName])))
2 Replies
- wdx223_Daniel
Community Champion
=SUMX(VALUES(Table[Product Display Name]),CALCULATE(DISTINCTCOUNT(Table[APIDisplayName])))