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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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

Top Solution Authors
Top Kudoed Authors