How to check if a value of a column is in another column

[paolo_troia]

Hi all,

hope you are well!

I am writing to you because I would like to create a third column to check if the value of the column "ID_Primary" is present in the  column "Placement". This third column should countain a True/False or maybe should colour in red if there is not a match.

This is a an example of database I created for the purpose, but the real database is much longer, so I should find a way to match the column "ID primary" with the column "Placement".

In the following link you can find the .pbix and the database:

https://drive.google.com/drive/folders/1-5E58YHIjmrmC6BAgJBrcKL3z2Lxj0CX?usp=sharing

Unfortunately, I cannot find a solution. Could you please check if there is a way to solve the problem?

Many thanks

Paolo

[mh2587]

if both the columns are text type then recommend the following dax

3rd column =  EXACT([ID_Primary],[Placement])

[HotChilli · Accepted solution]

Are you only checking if it's on the same row (i.e. not the whole column). If so,

in Power Query, add a custom column like:

Text.Contains([Column2], [Column1])

swap in your column names.

[amitchandak]

@paolo_troia , A new column

Measure  =

var _id = [ID primary]

return

if(isblank(countx(filter(table,[Placement] =_id),[ID primary])), 0,1)

[paolo_troia]

Hi Amitchandak,

thanks for you feedback but unfortunately it does not work.

I updated the .pbix with your code but I cannot find the solution.

For example, the third row should be False or 0 because the ID primary value "179453" is not present inside the Placement "Test Test Test" row.

https://drive.google.com/drive/folders/1-5E58YHIjmrmC6BAgJBrcKL3z2Lxj0CX?usp=sharing

Could you please check if there is a way to solve the problem?

Many thanks in advance

Paolo