topic Re: Matrix Row Subtotals Incorrect in Desktop

Matrix Row Subtotals Incorrect

mdol678 — Fri, 12 Apr 2024 12:36:08 GMT

Hi all, help please, the simple matrix visual that I created has incorrect totals for some columns only. This was created using the basic matrix visual tool. I have very little DAX knowledge.

Re: Matrix Row Subtotals Incorrect

Gabry — Fri, 12 Apr 2024 12:43:55 GMT

Are you using a measure? Paste the measure

Re: Matrix Row Subtotals Incorrect

Greg_Deckler — Fri, 12 Apr 2024 13:40:01 GMT

mdol678 First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

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

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8

Re: Matrix Row Subtotals Incorrect

mdol678 — Fri, 12 Apr 2024 14:35:36 GMT

Thank you for your response. This matrix was created using the basic matrix visual tool and selecting the appropriate fields for the row, columns and values. The data is coming from two different queries with a one to many relationship.

I did not create any measure specifically, its all automatic. I'm not sure if I know even how to view the DAX code behind the visual?

Re: Matrix Row Subtotals Incorrect

Anonymous — Mon, 15 Apr 2024 06:48:19 GMT

Hi mdol678 ,

Exceptions to the total value in the matrix are generally the result of calculations in the measure formula added to the value(and not the result of dragging the original field into the value for automatic aggregation). You can refer to the location of the following screenshot to see the fields or measures used in the created matrix.

Also I have made simple demos which I hope will help you understand.

result_ = COUNTROWS('Table')

assets = IF ( HASONEVALUE ( 'Table'[Status] ), COUNTROWS ( 'Table' ), COUNTROWS ( FILTER ( 'Table', 'Table'[Other] <> "No pass" ) ) )

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.