cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
OobuJoobu
Frequent Visitor

Trying to filter a table where a value is greater than a measure from a different table

I have a Table visual, which is made up from various items in 2 data tables. The tables are joined by a one to many relationship in a particular field.

 

Relevant Data:

Table called "ReqTracker" has a numeric whole number value called "Ask"

Table called "Tracker" has a measure called "CountAll"

 

I want to only show rows in my table visual where the Ask value is greater than the CountAll value for that particular row.

 

How could I do this please?

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@OobuJoobu , You have to create a measure like

 

if(sum(Table[Ask]) >= [CountAll] ,1,0)

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@OobuJoobu , You have to create a measure like

 

if(sum(Table[Ask]) >= [CountAll] ,1,0)

Perfect, thank you!

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors