Matching Text

[chonchar]

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 it will not work for text.

Match/No Match =

VAR MatchFake1 = SELECTEDVALUE('XX Line Staging'[XX Staging Item Deescription])

VAR MatchFake2 = SELECTEDVALUE('XX Lines'[Item Description])

VAR MatchFake3 = SELECTEDVALUE(Items[Item Description])

VAR MatchFake4 = SELECTEDVALUE('Order Lines'[Item Description])

Return

IF(MatchFake1=MatchFake2=MatchFake3=MatchFake4, "Match", "No Match"

)

Please keep in mind I am searching for a 4-way match on text so I can create a conditionally formatted column to populate match/no match in a KPI card in PBI. 

Any feedback would be great. Thank you,

Cam

[parry2k · Accepted solution]

@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]

@chonchar add a new column with following DAX expression:

Match/No Match Column = 
VAR __Count = COUNTROWS ( DISTINCT ( { Table[Desc1], Table[Desc2], Table[Desc3], 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! ❤️

[chonchar]

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?

[chonchar]

@parry2k do I need to create measures for each table column? It is only pulling  measures with that syntax.