Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 the "Tri1" I can't hide its sum because it is currently closed. Inside each hierarchy line I mixing up different things so it doesn't make any sense to have a number (even if it is an average or a maximum). Is it possible to hide this value? My current definitions are shown below as well.
@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