Exclude rows if two values in same table are the same

[Anonymous]

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              6

456     5              5

I want the filter to exclude key 456 from report.

Any help would be greatly appreciated.

[v-lili6-msft · Accepted solution]

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]

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

Eric

[Anonymous]

Create another column:
FILTER = IF(VALA = VALB,"Yes","No")

Then you can filter according to the value of the new column