Sub Category % Calculation with in the single datset

[AnilKumar]

Hi all,

I need to calculate the sub Category % i.e like below.

Please suggest any method to calculate it.

Thanks in advance.

Regards,

Vishnu Priya

[v-qiuyu-msft · Accepted solution]

Hi @AnilKumar, 

You can create a measure below: 

Measure = DIVIDE(SUM('Table'[Qty]),CALCULATE(SUM('Table'[Qty]),ALLEXCEPT('Table','Table'[Mod1],'Table'[Mod2],'Table'[Mod3])))

Best Regards,
Qiuyun Yu