Forum Discussion

Anonymous's avatar
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 c...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    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] )
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

Thanks for the suggestion 

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    7 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

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