Clustered column chart - GT% within the X axis category

[Anonymous]

I have a clustered column chart visualization which looks like this: 

What I would like to achieve to calculate GT%, but not using the real grand total, but the X-axis Category elements totals, for example: 

Category 1 Sub-category 1 should be 35,44%

and here is the breakdown of the cacluation: 
Summing up the Category 1 elements: 2879 + 1462 + 234 + 549 + 2600 + 399 = 8123

Then Category 1 GT will be divided by the Category 1 - Subcategory 1 = 2879 / 8123 = 35,44%

Which DAX calculation can I use, I tried ALLEXPECT and other functions without success. 

[Uzi2019]

Hi @Anonymous 
Simply try below measure

subtotal =

var a= CALCULATE(SUM(Table[Sales]),ALL(Lumix[Sub Catrgory]))

var b= DIVIDE(SUM(Table[Sales]),a,0)

return b

I hope i answered your question!

[Ritaf1983 · Accepted solution]

Hi @Anonymous 

You can use a measure :

Percentage classes = DIVIDE([your regular measure],CALCULATE([your regular measure],ALLSELECTED('your table'[subcategory])))
For example :

Percentage classes = DIVIDE([orders qty],CALCULATE([orders qty],ALLSELECTED('orders'[Ship Mode])))

Will give as a result :

The pbix is attached 

 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[Anonymous]

How obvious... thank you so much! 🙂

[Ritaf1983]

Happy to help😊