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] )
Thanks for the suggestion parry2k! Do you know other way without Lastnonblank?
parry2k
Super User
Super UserAnonymousdid you tried what I proposed? You can choose any aggregation function like MAX/MIN or SELECTEDVALUE
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
I did, and multiple variations work the same way. Thanks for sharing Parry!