How to calculate percentage by group row...

[Anonymous]

I have the followig data model:

Name 1	$ 30,000.00
Product 1	$ 10,000.00
Product 2	$ 20,000.00
Name 2	$ 50,000.00
Product 1	$ 40,000.00
Product 2	$ 10,000.00
Total	$ 80,000.00

I need to calculate the % of each line grouped by Name in order to have the following:

Name 1	$ 30,000.00	100%
Product 1	$ 10,000.00	33%
Product 2	$ 20,000.00	67%
Name 2	$ 50,000.00	100%
Product 1	$ 40,000.00	80%
Product 2	$ 10,000.00	20%
Total	$ 80,000.00

I could only manage to show the % based on the grand total, but I need exaclty what I´m showing above. Any idea?

[Icey · Accepted solution]

Hi @Anonymous ,

Is your table like below?

If so, you can create your measure like so:

Percent =
DIVIDE (
    SUMX ( 'Table', 'Table'[Value] ),
    CALCULATE ( SUM ( 'Table'[Value] ), ALLEXCEPT ( 'Table', 'Table'[Name] ) )
)

Best Regards,
Icey

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

[amitchandak]

Please refer

https://community.powerbi.com/t5/Desktop/Percentage-of-subtotal/td-p/95390

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
Thanks.