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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

SumPaid less selected value in separate table

I'm working with two duplicate tables, one being the location table and the other the market table. Trying to compare location to the whole market. In order to get an accurate comparison to the market, I have to add a measure where sum Paid in the market table less the selected slicer location in the location table. 

 

Was using this.... but it doesn't seem to be working right.

Paid Less Selected Location = VAR SelectedLocation = SELECTEDVALUE('Location'[Location_Name])
return
CALCULATE(SUM('Market'[Paid]), 'Market'[Location_Name]<>SelectedLocation)
 
Can anyone help me understand what I'm doing wrong? Seems like a fairly straight forward measure. 
1 REPLY 1
lbendlin
Super User
Super User

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors