display matrix with measures on different hierarchical levels

[Anonymous]

Hello, I need to build a matrix with three measures on the values section, but for two of them I need to show only the totals. On the columns section I have a hierarchy column , like in the attached image. I could obtain this easily with a table, but the request is to have a dynamic display in case new children appear under the parent. Is this something which I could achieve using a matrix?Thank you.

[amitchandak]

@Anonymous , refer if this can help

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

https://www.sqlbi.com/articles/clever-hierarchy-handling-in-dax/

[Anonymous]

Hello @amitchandak , @Greg_Deckler , using these approaches it would still break the budget by each value of the heirarchy column. What I need is to show the budget only for the total column.. Thank you

[v-easonf-msft · Accepted solution]

Hi , @Anonymous 

Sorry, after my research, it is difficult to achieve in matrix.

I can't find any solution currently.

If you get any workaroud,please kindly share it here  so that others having similar concern can find the answer more easily.

I will still keep an eye on it.

Best Regards,
Community Support Team _ Eason

[Greg_Deckler]

@Anonymous - Not sure I follow, MM3TR&R allows you to explicitely define what to show at any level of the hierarchy. If you want to show BLANK(), just code it to show BLANK() at that level of the hierachy but otherwise display a SUM or something.

[Greg_Deckler]

@Anonymous - Check out MM3TR&R - https://community.powerbi.com/t5/Quick-Measures-Gallery/Matrix-Measure-Total-Triple-Threat-Rock-amp-Roll/td-p/411443