Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Row total wrong in Matrix report

    See Attached , Does any one know why Power BI matrix visual calculating wrong totals??
  • amitchandak's avatar
    6 years ago

    Anonymous , Is is a count distinct measure. Or a measure uses IF, isfiltered etc. In a measure, a grand total is recalculated. So there can few reasons around it. Share you measure formula

  • AllisonKennedy's avatar
    6 years ago

    Are you using a distinct count? 


    If yes, what that image tells me is that you have a total of 422 DISTINCT Sales Order Numbers in the table. Some of those numbers (about 30 from the numbers in your image) might be listed twice, so are Partial and also Full. 

     

    If that doesn't help or make sense, can you please elaborate on where the FULL/PARTIAL information comes from and if it is in the same table or related table to the Sales Order Number?

     

    Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved. 

     

    If you found this post helpful, please give Kudos.

    I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query. 

    https://sites.google.com/site/allisonkennedycv