Forum Discussion

chonchar's avatar
chonchar
Helper V
3 years ago
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...
Need Help
  • parry2k's avatar
    parry2k
    3 years ago

    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! ❤️

parry2k's avatar
parry2k
Super User
3 years ago

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! ❤️