Row total wrong in Matrix report

[Anonymous]

See Attached , Does any one know why Power BI matrix visual calculating wrong totals??

[amitchandak · Accepted solution]

@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 · Accepted solution]

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

[Greg_Deckler · Accepted solution]

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

[AllisonKennedy · Accepted solution]

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

[Anonymous]

Thanks , this works , I have certain orders which were in both full and partial so dupes, matrix is counting distinct orders correctly.

[amitchandak · Accepted solution]

@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