How to create dynamic dimension and expression using drill through drill down and hirercy ?

[Paulyeo11]

Hi All

May i know how to achieve below by above mentioned ?

https://www.dropbox.com/s/lqtacfyj7p09l4h/DYNAMIC%20MEASURE.pbix?dl=0

[v-jayw-msft]

Hi @Paulyeo11 ,

I don't quite understand what you want, can you show more details?

Best Regards,

Jay

[Paulyeo11]

Hi Jayw

Thank you for reply my post.

For example if you look at the image i posted . 

i need the Dimension to be dynamic.

The Dimension i have Brand , Product Class , Product Type , Segment ETC

So user can start with selet YTD sales by Brand.

And user can click on Brand A or Brand B , for drill down.

and I can change the dimension to Product Class.

Paul Yeo 

[Paulyeo11]

Hi All 

in case some one know that solution pls share