Showing matrix subtotal in a Pie Chart

[YYlee]

Hi there,

I’ve attached my draft graph in Power BI. I’d like to display values in a pie chart with a Matrix subtotal as follows:'

I create the Matrix by using BI matrix itself. 

1. If no filters are selected, the pie chart should show the total of the categories divided by 6 people.
2. If I select "Junior," the pie chart should display (6.11 / 1.02 / 1.56) / 2
3. If I select "Senior," the pie chart should display (7.43 / 4.1 / 6.91) / 4 

I’ve reviewed some solutions in the group but haven’t been able to get it to work. Any assistance would be appreciated.

I appreciate the help. Thanks. 

Regards, 

YY

[YYlee]

Dear @Ritaf1983 , Thank you for your offer. 

I solve it with @Anonymous's help. 

Thank you both 🙂

[Anonymous · Accepted solution]

Thanks for Ritaf1983's concern about this case.

Hi  @YYlee , 

I tried to create a sample data myself based on your requirement and implemented the result. Please check if there is anything that can be improved. Here is the steps:

1.Create a simple data:

2.Create a new measure:

MEASURE =
VAR _sum =
    CALCULATE (
        SUM ( 'Table'[Value] ),
        ALLEXCEPT ( 'Table', 'Table'[Category], 'Table'[Column] )
    )
VAR _people =
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[Name] ),
        ALLEXCEPT ( 'Table', 'Table'[Category] )
    )
RETURN
    DIVIDE ( _sum, _people )

3.Use the measure you just created as the pie chart value.

 

4.The final result is as follows:

 

Best Regards,
Zhu
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[Ritaf1983]

Hi @YYlee 

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly