Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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.
Solved! Go to 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
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
Thanks! That worked great! I used TRUE and FALSE instead of "yes" and "no"
Eric
Create another column:
FILTER = IF(VALA = VALB,"Yes","No")
Then you can filter according to the value of the new column