power bi decomposition tree: % of subtotal

[rainerpowerbi]

Hi,
decomposition-tree gives only the option showing share of an element in % of COMPLETE-TOTAL.

Is there an trick/option, that I can show the percent of the direct parent-level ?

(It is very important that user has to have further full flexibilty changing the chosen/selected elements (not fixed elements-structure as in other solutions).

My Goal-structure: (user can change element-structure complete free)

For me this feature (% of subtoatl) is absolutely necesarry for user-acceptance.

Kind regards

Rainer

[rainerpowerbi]

Hi amitchandak,
thanks a lot for your answer !

I regret that in your and other solutions the user has no option to place the levels IN A COMPLETE FREE STRUCTURE. I hope that Microsoft will provide this feature (% of subtotal)  as soon as possible to increase user-acceptance.

Kind regards

Rainer

[amitchandak · Accepted solution]

@rainerpowerbi , You have to use isinscope and switch measure, but remember, you can not have it fully dynamic , which means if you swap country and product it might not work

Please find all measures 

M1 = divide([measure], calculate([Measure], allselected())

M2 = divide([measure], calculate([Measure], filter(allselected(Table), Table[Country] = max(Table[Country]) ))

or

M2 = divide([measure], calculate([Measure], allselected(Product)) //if product is separate dimension

Switch( True() ,

isinscope(Product[Product]), [M2],

[M1]

)

You can extend the switch with more conditions 

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