Forum Discussion

Anonymous

Not applicable

2 years ago

Matrix Visual Total

Hello, I'm working with matrix visual and I would like to hide all types of sums that exist. For the example below, I'm able to hide the sum from "abril" because this is an open hierarchy, as for t...

Matrix Subtotal

Community Champion

2 years ago

Anonymous 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

Also, check out this. In your case, you would want to return BLANK for any hierarchy level that is not the lowest. (3) Matrix Measure Total Triple Threat Rock & Roll - Microsoft Fabric Community