Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
hkrash0920
Helper I
Helper I

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
v-chuncz-msft
Community Support
Community Support

@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.

View solution in original post

4 REPLIES 4
v-chuncz-msft
Community Support
Community Support

@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.

@v-chuncz-msft 

Thank you for your reply. It also helped me. 
Would it be possible to keep these values fixed when the user uses the slicer to filter by "Svc Code" ? 
Because at the moment, in this case, the percentage becomes 100%.

Example: User filter per "CAP"

Current Result:

Eng PartnerSvc CodeFY18 YTD TER 
Smith, JaneCAP$17,409100%
Jones, JoeCAP$207,531100%


Desired Result:

Eng PartnerSvc CodeFY18 YTD TER 
Smith, JaneCAP$17,4094.66%
Jones, JoeCAP$207,53167.52%


Thank you so much in advance!

Kind regards, 
Jéssica

Thanks...It worked. Appreciate it.

 

 

Anonymous
Not applicable

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.