Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Solved! Go to 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.
This did solved it. And I also understand why. Thanks
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?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
58 | |
50 | |
44 | |
21 | |
19 |