cancel
Showing results for
Did you mean:
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 Partner Svc Code FY18 YTD TER Smith, Jane CAP \$17,409 4.66% Smith, Jane RD \$220,828 59.10% Smith, Jane RER \$47,433 12.69% Smith, Jane S199 \$88,010 23.55% Total \$373,680 Jones, Joe CAP \$207,531 67.52% Jones, Joe INV \$14,734 4.79% Jones, Joe ME \$11,468 3.73% Jones, Joe RER \$10,860 3.53% Jones, Joe S174 \$5,440 1.77% Jones, Joe S199 \$56,667 18.44% Jones, Joe TCA \$646 0.21% Total \$307,346 Grand Total \$681,026
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team

## Re: Subtotal Percentages

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

Regards,

ManNVSM.

Highlighted
Community Support Team

## Re: Subtotal Percentages

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.
Regular Visitor

## Re: Subtotal Percentages

Thanks...It worked. Appreciate it.