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 am using version: 2.68.5432.841 64-bit (April 2019). I get a wrong column total while using the matrix view.
1-cells inside the matrix sum up to 2196
2-column total is 2252
3-The error is discovered exporting the view to excel, where the total goes back to the correct value (2196)
Can anybody help?
Solved! Go to Solution.
Totals are figures where there are less ( or no ) filters applied. Each figure you see is calculated independantly of each other and the fact that the totals add up to the sum of the figures before it is happenstance. So the total you see is correct, just not what you'd expect. Without seeing more of the data, you can use something like:
Measure = SUMX ( VALUES( what you want to sum), CALCULATE ( [Your Measure Here] ) )
Totals are figures where there are less ( or no ) filters applied. Each figure you see is calculated independantly of each other and the fact that the totals add up to the sum of the figures before it is happenstance. So the total you see is correct, just not what you'd expect. Without seeing more of the data, you can use something like:
Measure = SUMX ( VALUES( what you want to sum), CALCULATE ( [Your Measure Here] ) )
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |