Forum Discussion
Filter report when one column does not match another column from a different table
Hi, biotechanalyst
Based on your description, I have created the following two tables:
The relationship is as follows:
You'll need to create a measure as follows:
Measure = IF(SELECTEDVALUE('Table2'[Functional currency])=SELECTEDVALUE('Table'[currency code]),1,0)Place this metric in the filter panel as follows:
I've provided the PBIX file used this time below.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
this is the exact same Dax I've tried already
mismatch = IF(SELECTEDVALUE('Company Hierarchy'[Functional Currency]) = SELECTEDVALUE('Vendor Spend Summary'[Currency Code]), "True","False")
How is your solution different than the dax ive already tried? I also cannot make this measure a filter/slicer for the page
Thanks Ritaf1983 ,your solutions is great.
Hi, biotechanalyst
If you need to add a calculated column, you can create a calculated column by following the DAX expression provided by super user for filtering in your report. The main reason for your error is that you are using the RELATED function on side 1 of the table. You should use this function on the * side of the table, as shown in the following figure:
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.