Forum Discussion
Wrong Total
Hi Everyone, I am creating a measure, Measure = divide(sum(amount),count(task)), this is giving me incorrect total. This is a sample data, in whic...
Thanks, i will give it a try.
Hi v-yulgu-msft,
I have used the same calculation as shared, below are some snips. Could you please help me in this.
Here is a link to the PBIX, with some sample data.
https://www.dropbox.com/s/pfm564aq1lo3tgl/Total%20issue.pbix?dl=0
If you see in the first screenshot, it seems working fine with one dimension only, i.e Sname, the column name wrong total is sum(amount)/count(sid), the total of this calculation is incorrect,
The column correct total gives the correct output and the expression used is
SUMX(VALUES(SID[Sname]),CALCULATE(SUM(Final[Amount]))/CALCULATE(COUNT(Final[Sid])))
Now in the second screenshot, it gives incorrect total, when another dimension Pname is dragged along with existing dimension Sname.
Thanks,
Abhishek Pandey