Forum Discussion

mdol678's avatar
mdol678
Regular Visitor
2 years ago
Solved

Matrix Row Subtotals Incorrect

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.   ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

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

mdol678's avatar
mdol678
Regular Visitor
2 years ago

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?