topic Re: Problem with the totals when a percentage is in it in DAX Commands and Tips

Problem with the totals when a percentage is in it

Anonymous — Wed, 03 May 2023 10:34:42 GMT

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?

Re: Problem with the totals when a percentage is in it

Anonymous — Wed, 03 May 2023 12:24:41 GMT

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?

Re: Problem with the totals when a percentage is in it

v-zhangti — Fri, 05 May 2023 03:55:31 GMT

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.

Re: Problem with the totals when a percentage is in it

Anonymous — Fri, 05 May 2023 08:04:55 GMT

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