Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

Filter table rows where Col 1 = Col 2 by DAX

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?

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