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

[OobuJoobu]

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?

[amitchandak · Accepted solution]

@OobuJoobu , You have to create a measure like

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

[OobuJoobu]

Perfect, thank you!