based on drill down, the ratio should values

[Anonymous]

i need to measure like if i drill down apparel, in pricing driver, i need ratio is like base pricing  by netshipped gms pd /total(3015266/25229318), each each gl, it should give each pricer driver 1 net shipped gms pd, total of each gl.. same if expand pricing driver 1 netshipped gms pd .total(2139/3015266) ratio per gl should come like that. Please help with the measure.

[v-eqin-msft · Accepted solution]

Hi @Anonymous ,

Got it. You may fistly calcualte the sum of each pricing driver1/2 by using ALLEXCEPT() , and then try ISINSCOPE() to change sub-total of rows in matrix.

But we need some data sample for quick assist.

You may refer to the blogs to know

How to Get Your Question Answered Quickly - Microsoft Power BI Community

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,
Eyelyn Qin