Forum Discussion

geoB's avatar
geoB
Regular Visitor
9 years ago
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...
  • samdthompson's avatar
    samdthompson
    9 years ago

    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?

  • geoB's avatar
    geoB
    9 years ago

    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.

     

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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?

geoB's avatar
geoB
Regular Visitor
8 years ago

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