Extract Values

[chonchar]

Hello,

I have the below DAX that identifies if there is a perfect four-way match on certain item descriptions. Now, I need to be able to pull the values that would populate in a table if there was a list of the "no match" descriptions. Do I create a table with the same DAX, or??? I am lost.

My desired result is to identify all of the values that would read "no match" from this DAX and then put them in a table. Sharing the PBI file is not an option under any circumstances. 

4-Way Description Match =

VAR __Count =

COUNTROWS (

   DISTINCT ( {

        SELECTEDVALUE ( 'Table1'[Description1] ),

        SELECTEDVALUE ( 'Table2'[Description2]),

        SELECTEDVALUE ( Table3[Description3] ),

        SELECTEDVALUE ( 'Table4'[Description4] )

} ) )

RETURN

IF ( __Count = 1, "Match", "No Match" )

                                                ^^^^^ -This no match is what I want a table of.

Best,

Cam

[parry2k]

@chonchar I have no idea what you are talking about. Please provide more details. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[parry2k]

@chonchar you can do something like this:

New Table = FILTER ( YourOriginalTable, YourOriginalTable[Matching Column] = "No Match" )

[chonchar]

@parry2k it is actually four tables. So, do I embed that FILTER in the original DAX but as a new table? Becasue the "No Match" doesn't actually exist in the model.