Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Win a FREE 3 Day Ticket to FabCon Vienna. Apply now

Reply
Anonymous
Not applicable

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              6

456     5              5

 

 

I want the filter to exclude key 456 from report.

 

Any help would be greatly appreciated.

 

1 ACCEPTED SOLUTION
v-lili6-msft
Community Support
Community Support

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"

1.JPG

 

Best Regards,

Lin

 

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-lili6-msft
Community Support
Community Support

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"

1.JPG

 

Best Regards,

Lin

 

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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

 

Eric

 

Anonymous
Not applicable

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

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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.