Forum Discussion
Solved
Matching Text
Hello, I am trying to perform a four-way match from four different tables. The problem is that I am trying to match text rather than numbers. I beleive the below DAX would work for numbers, but i...
chonchar Add as a measure:
Match/No Match Measure = VAR __Count = COUNTROWS ( DISTINCT ( { SELECTEDVALUE ( Table[Desc1] ), SELECTEDVALUE ( Table[Desc2] ), SELECTEDVALUE ( Table[Desc3] ), SELECTEDVALUE ( Table[Desc4] ) } ) ) RETURN IF ( __Count = 1, "Match", "No Match" )👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️
I completely understand the sytnax, but PBI is not populating the other tables after:
Table[Column1]. Is there something I am missing? does distinct not pull table1[column1], table2[column2]...etc?