How to show the % of subtotals?

[Anonymous]

Hi,

I am trying to show each manufactuer as a % of product type NOT as a % of all/totalproducts.

Example:

Product  Manufactr   Units   %ofProd    %ofTotal

Cars       Mfctr#1       50           67%           45.5%

Cars       Mfct#2        25           33%           22.7%

Cars                          75          100%         68.2%

Trucks    Mfct#1        20           57%           18.2%

Trucks    Mfct#3        15           43%           13.6%

Trucks                      35          100%          31.8%

Total                         110                           100%

I know how to find the % of total but how do I calc / show the "% of Product" as shown above? 

Thank you for any help in advance!

[v-qiuyu-msft]

Hi @Anonymous,

In your scenario, you can use @Sean's DAX expression to get percentage of products. Then format the measure to return percentage format values. You can know how use AllExcept() function from this article: Favorite Quick & Easy DAX: Calculate Percent of Total Scenario. Please refer to final results:

If you have any question, please feel free to ask.

Best Regards,
Qiuyun Yu

[pstanek]

For me result of that is the same.

https://community.powerbi.com/t5/Desktop/Percent-of-certain-group/td-p/70930?lightbox-message-images...

Plus I can´t find divide fuction in desktop.

My  biggist problem is the column  --month , I need 100% for each month , not only for total.

[Sean · Accepted solution]

@Anonymous 

% of Product =
DIVIDE (
    SUM ( 'Table'[Units] ),
    CALCULATE ( SUM ( 'Table'[Units] ), ALLEXCEPT ( 'Table', 'Table'[Product] ) ),
    0
)