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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.