percentage subtotals

[chriscorpion786]

Hi All,
Im trying to find a DAX solution to evaluate percentages for subtotals. I have 2 columns, SubFamily and within it I have Brand names, so I need to find the percentage of each
Brand within that Sub family and the sub family should also show percentage of the grand total.
It will be clear in the attached image I have uploaded. Iron Steam is a sub family name so the 12.2% share shows its weight in the category of sub family name, at same time,within this category there are many brands for e.g Philips shows 34.95% share withing the Brands. All these are correct and I got a solution from the internet, but I didnt understand it.
Is there a better way of writing it in DAX which makes more sense to do this.
Please help.

 

[chriscorpion786]

Hi Justina,
Very clear on the Countrows formula. Thanks for the great explanation.
By the way, my table EPOS is a standalone table. Anyways, we got the formula working and it seems pretty straight forward and easy to understand with the isinscope functiton.
I have another question regarding price segmentation and will post it today under the heading "Price Segmentation". Please do have a look if you get the time.
Many thanks....

 

[JustynaMK]

I will do that. Many thanks for a very pleasant collaboration on this topic