Custom Matrix : Row subtotals are the value of a column

[Anonymous]

Hi,

I have the table below : 

Name	Power	Group	Status
Group A	2500		On
Group B	400		OFF
Group C	1200		Pending
Group D	1200		On
Group E	600		Pending
Group F	3600		On
Name 1	200	Group A	On
Name 10	600	Group F	On
Name 11	1000	Group F	On
Name 2	200	Group A	On
Name 3	300	Group B	OFF
Name 4	400	Group C	Pending
Name 5	600	Group C	Pending
Name 6	200	Group F	On
Name 7	100	Group C	Pending
Name 8	200	Group D	On
Name 9	200	Group D	On

I would like to create the following matrix , the row subtotals are the value of the column Power

Could you please help. 

Many thanks in advance. 

[Anonymous]

HI @Anonymous,

According to your snapshot, It seems like you are working with parent child hierarchy structure. I'd like to suggest you take a look the following blog about parent child hierarchy structure and how to analyze them in power bi.

Parent-child hierarchies – DAX Patterns

Regards,
Xiaoxin Sheng