Forum Discussion
Solved
Incorrect matrix row total
A matrix report shows expected values and correct column totals. The displayed row totals are not equal to the sum of the row values. A snip of the report: Surely 8+21+9+32 !== 59; 259+454+11...
Do you have a visual level filter on for site types with a total measure that contains an ALL() function? That would explain why you have column totals correct but row totals incorrect. Are you able to share the PBIX?
The report will show the correct row totals if the SQL statement that appears above is used at Get Data. This seems to reduce the value of PBI Desktop if identical results are not possible without pre-selecting data.
Do you have a visual level filter on for site types with a total measure that contains an ALL() function? That would explain why you have column totals correct but row totals incorrect. Are you able to share the PBIX?
I had an ALL() in one of my measures. Once I cleared that, the rows were corrrect. Thank you!