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

## Divide sum of one column by sum of another column with applied slicer

I have the below data table.

 Loan Number Loan Amount Divisional bps Div Concession \$ Actual Div BPS 1707292 \$1,094,180 0.5 \$5,470.90 0 1801566 \$456,300 1.12 \$5,110.56 0 1802860 \$340,000 1.391 \$4,729.40 0 1801866 \$843,406 0.45 \$3,795.33 0 1803235 \$502,500 0.75 \$3,768.75 0 1801466 \$679,650 0.527 \$3,581.76 0 1801730 \$300,000 1.115 \$3,345.00 0 1715250 \$222,400 1.504 \$3,344.90 0 1707887 \$1,000,000 0.332 \$3,320.00 0 \$5,438,436 \$36,466.60

For actual DIV BPS i'm using the below calculation:

Actual Div BPS = SUM('LoanMaster (2)'[Div Concession \$])/Sum('LoanMaster (2)'[Loan Amount])

It's not pulling correctly when I have either a Date or Sales Person Slicer applied. Not sure how to get this to work.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Regular Visitor

## Re: Divide sum of one column by sum of another column with applied slicer

Figured it out! had to do Measures not columns! 1 for each total then divide!

1 REPLY 1
Highlighted
Regular Visitor

## Re: Divide sum of one column by sum of another column with applied slicer

Figured it out! had to do Measures not columns! 1 for each total then divide!

## Helpful resources

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 273 members 3,162 guests
Recent signins:
Please welcome our newest community members: