Filter on record existing in a related table

[Anonymous]

I have 2 tables: many Stages to each Request. Both tables coming from a SQL database.

In Power BI, I want to allow easy filtering of all the Requests which have a Stage of type 'ABC'.

This is the logic I would use in SQL:

select Requests.RequestId
from Requests
where RequestStatus = 'Active'
and exists (select *
                  from Stages
                  where Requests.RequestId = Stages.RequestID
                  and Stages.StageName = 'ABC')

The SQL above returns the Request records I'm interested in.

My idea is to add a new column to the Request table in Power BI, and allow filtering on that new column.

But I can't work out the DAX syntax for my new column.

My two tables are joined/related in Power BI.

Thanks for any help 

[Anonymous · Accepted solution]

I found one way to solve this. Posting my answer in case it might help someone else ...

My new column on the Requests table:

Request Has ABC Stage = COUNTROWS(FILTER(RELATEDTABLE(Stages),Stages[StageName]="ABC"))>0

This gives a nice True/False value at Request level, for use in filters.

Any alternative answers would be gratefully received too