Forum Discussion
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 c...
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] )
Anonymousdid you tried what I proposed? You can choose any aggregation function like MAX/MIN or SELECTEDVALUE
I did, and multiple variations work the same way. Thanks for sharing Parry!