Problem with the totals when a percentage is in it

[Anonymous]

Hi,

I have a calculated measure (Let's call it A) that is being displayed in a matrix in Power BI with the rows which are countries. We are filtering the countries so only a few are shown. My problem is that the total of the column is wrong:

	A
Italy	99291,10
Brazil	1569087,53
Total	1679632,91

  The formula for A is:

A = DIVIDE(

                   CALCULATE(B,'C'[C1]="ABC"),

                   CALCULATE([D %])

)

B and D are other calculated measures. B returns a number but D returns a percentage. The formula for D is:

D = Divide(E, F)

When I put all B,D,E,F also in the matrix the total of all of them works correclty but not for the A.

How can I fix this?

[Anonymous]

This did solved it. And I also understand why. Thanks

[Anonymous]

I just checked and found out this:

Countries	A	B	D %
Italy	99291,10	53402	53.78%
Brazil	1569087,53	1077107	68.65%
Total	1679632,91	1130509	67.31%

So, Although the sum of the column A rows doesn't add up to A's total but it seems that if I use the formula on the total of B and divide it by the total of D %, The result can match to total of A. But how can I change the total of A so that it just calulcates the actual sum of it's rows?

[v-zhangti · Accepted solution]

Hi, @Anonymous 

You can try the following methods.

Measure = 
Var _table=SUMMARIZE('Table','Table'[Countries],"Sum",[A])
Var _Sum=SUMX(_table,[Sum])
Return
IF(HASONEVALUE('Table'[Countries]),[A],_Sum)

For reference:

Solved: wrong total of measure - Microsoft Power BI Community

Hope this helps.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.