Forum Discussion
Solved
DAX contains
Hi, I will try to keep this as simple as i can I have a four column table a,b,c,d, and at least one row of each has the word cat or dog, If I write a measure CONTAINS( Table2, Table2[A], "d...
hello,
i think like that you check row by row, so you need to have in the same row Table2[A], "dog",Table2[B], "dog", Table2[C], "cat",Table2[D] ,"cat".
Do you have a row where all those conditions are met?
I have realised that it refers to a row all being true not just any row of each column being true.
Richard
