CODEWITHSUNDEEP
powerbipowerquerycontainsselectedvalue
Ignacio Maillo
Ignacio Maillo

Reputation: 1

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

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

Upvotes: 0

Views: 99

Answers (1)

andrew
andrew

Reputation: 1

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

Upvotes: 0

Related Questions