Filter table rows where Col 1 = Col 2 by DAX

[Anonymous]

Objective: Filter the table with only Rows in which C1_Name = C2_Name

Don't want to see rows that do not have any record associated in the factual, like NOT USED = NOT USED

Limitation: Cannot add calculated columns, only use DAX. This is because you only have access to the model in Direct Query mode.

Any idea on how to solve this in a good way?

[parry2k · Accepted solution]

@Anonymous you can add below red code next to calculation of your flag matching measure  

Flag Matching Currencies =

<your existing if condition> 
*
DIVIDE( [Total Transaction Value], [Total Transaction Value] )

[Anonymous]

Thanks for the suggestion parry2k! Do you know other way without Lastnonblank?

[parry2k]

@Anonymousdid you tried what I proposed? You can choose any aggregation function like MAX/MIN or SELECTEDVALUE

[Anonymous]

I did, and multiple variations work the same way. Thanks for sharing Parry!

[Anonymous]

@Anonymous -

As @parry2k said, you could use various Aggregate functions. Measures require an aggregation, because they're calculated within a Filter context, and not in the context of a single table row.

In your case, each Visual row filters each of your columns to a single value. Therefore, MIN, MAX, LASTNONBLANK, SELECTEDVALUE all return the same thing. 

Cheers!

Nathan