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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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