Column that returns true when a related table contains a specific value in a column

[MHatMFT]

I have a table of sales order data, and a second, linked table that contains information about communications with customers in relation to the sales orders. The second table has a column called "category". What I would like to do is add a column to the sales data table that flags true if there is a note in the second table with a specific category. Is this doable?

There will be other categories in the second table that need to be ignored, and there may be more than one note tagged as the category I want to look for.

[Anonymous]

Hi @MHatMFT ,

Any updates?

Best Regards,
Eyelyn Qin

[Anonymous]

Hi @MHatMFT ,

Yes, you could do that.

But we need more details about your table and your expected output to clarify your scenario.

Could you please provide some dummy data or share with your pbix file after removing sensitive data?

For reference:

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

How to Get Your Question Answered Quickly - Microsoft Power BI Community

Best Regards,
Eyelyn Qin

[johnt75 · Accepted solution]

You can add a calculated column something like

Has note on category = NOT( ISEMPTY( 
FILTER( RELATEDTABLE( Notes ), Notes[Category] IN { "category 1", "category 2" } )
))

[MHatMFT]

Thanks, that worked