Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
89 | |
88 | |
35 | |
35 |
User | Count |
---|---|
152 | |
99 | |
82 | |
63 | |
54 |