cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hkrash0920 Regular Visitor
Regular Visitor

Subtotal Percentages

Hi...I am trying to get the percentage of sub totals. See the below Excel file. For example for Jane Smith, we have percentages for CAP, RD, RER, and S199 which shows the percentage that CAP is compared to the subtotal for Jane Smith of $373,680. The formula I have in Excel is for CAP is $17,409 / $373,680 = 4.66% or for RD is $220,828 / $373,680 = 59.10%. Any ideas on how I do this in Power BI?

 

Thanks

 

 

Eng PartnerSvc CodeFY18 YTD TER 
Smith, JaneCAP$17,4094.66%
Smith, JaneRD$220,82859.10%
Smith, JaneRER$47,43312.69%
Smith, JaneS199$88,01023.55%
 Total$373,680  
Jones, JoeCAP$207,53167.52%
Jones, JoeINV$14,7344.79%
Jones, JoeME$11,4683.73%
Jones, JoeRER$10,8603.53%
Jones, JoeS174$5,4401.77%
Jones, JoeS199$56,66718.44%
Jones, JoeTCA$6460.21%
 Total$307,346  
 Grand Total$681,026  
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: Subtotal Percentages

@hkrash0920,

 

You may add a measure as shown below.

Measure =
DIVIDE (
    SUM ( Table1[FY18 YTD TER] ),
    CALCULATE ( SUM ( Table1[FY18 YTD TER] ), ALLSELECTED ( Table1[Svc Code] ) )
)
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
ManNVSM Member
Member

Re: Subtotal Percentages

Dear @hkrash0920,

 

Incase of keeping the original Value, just clone new measure column and using using "Show value as > Percent of column Total".

 

 

image.png

 

 

Regards,

ManNVSM.

Highlighted
Community Support Team
Community Support Team

Re: Subtotal Percentages

@hkrash0920,

 

You may add a measure as shown below.

Measure =
DIVIDE (
    SUM ( Table1[FY18 YTD TER] ),
    CALCULATE ( SUM ( Table1[FY18 YTD TER] ), ALLSELECTED ( Table1[Svc Code] ) )
)
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hkrash0920 Regular Visitor
Regular Visitor

Re: Subtotal Percentages

Thanks...It worked. Appreciate it.