Forum Discussion
Row total wrong in Matrix report
- 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
- 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.
- 6 years ago
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
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.
- Anonymous6 years agoNot applicable
Thanks , this works , I have certain orders which were in both full and partial so dupes, matrix is counting distinct orders correctly.