Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Exclude rows if two values in same table are the same

I'm trying to figure out how to create a filter which will exclude rows in my report if values in two separate columns are equal.   For example:   KEY     VALA       VALB 123     5              ...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, Anonymous

    there is a simple way that create a calculate column to judge if two values of the current row are the same

    judge = IF(Table1[VALA]=Table1[VALB],"yes","no")

    then drag the field into report level filter to filter value is "no"

     

    Best Regards,

    Lin

     

     

v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

hi, Anonymous

there is a simple way that create a calculate column to judge if two values of the current row are the same

judge = IF(Table1[VALA]=Table1[VALB],"yes","no")

then drag the field into report level filter to filter value is "no"

 

Best Regards,

Lin

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks!  That worked great!  I used TRUE and FALSE instead of "yes" and "no"

     

    Eric