DAX to check if value in table is contained in unrelated table POWER BI

69 Views Asked by At

I have the following table

enter image description here

which I am going to filter through a slicer. Let's say I selected fund AAA.

and I would like to add a column in the following table

enter image description here

to check whether the CPTY is contained in the CONCAT column for the selected fund.

a dax formula to calculate the column with an explanation

1

There are 1 best solutions below

0
andrew On

You can use selectedvalue() in order to select know which value is on the filter