I have two tables – table A with customer, sales-id, sales-part and sales. table B with sales-part and identifier (Y/N). I need a measure to filter for sales-id when sales-part has identifier=Y. table A and table B have many to 1 relationship.

My output should have data for entire sales-id if a sales-part has identifier=Y.

I tried building a measure with if condition within Calculate and filter but won’t work.

Thanks for your help in advance!

Table A and table B are attached as images

enter image description here
enter image description here

My output should have data for entire sales-id if a sales-part has identifier=Y.

enter image description here