Forum Discussion
Incorrect matrix row total
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.
I'm glad to know the explanation. My efforts to create the expressions you suggest have not yet been successful. And I've taught Excel & Access at the local community college in the not too distant past. While I don't believe the organization I'm researching this for could figure all this out I'd very much like to see how it's done. Can you suggest some documentation that would enlighten me?
The more I think about this the more absurd the situation appears. I cannot imagine a scenario where it is appropriate to apply an algorithm other than summing the row values. Under what circumstance is displaying a value other than the sum of row values appropriate? Why should this not be considered a bug?
Hi geoB i ran into the same problem, and completely agree with your thoughts there can't be a situation when this unique values row sum makes sense.
By any chance did you figure a way around to display the right sum values?
Thanks for duplicating the result - suggests it wasn't my bad design! Given that I was effectively told the result was by design and that I could never find a work-around I gave up with BI. Off to smaller and better things.
Good luck.
g