Forum Discussion
Finding / Displaying Mismatch Between 2 Columns in Different Tables
Thank you for the response, but this will not work for me. The 2 tables do not have the same amount of columns. The objective is, in Visual A it is showing a filtered data set from Table 1, while in Visual B it is also using the same filters, but using a data set from Table 2. And from those 2 filtered data sets, i need to display the fields that mismatch.
I believe I need to use a measure to properly do this, but where i get stuck is that these are text fields, therefore i cannot aggregate them to be used in a measure. Using the MAX of each text field in order to be able to use a measure will not work either since it is only taking the field with the largest length.
hi, Anonymous
Based on my test, you may try to use NOT and IN Function to add a measure as below:
Step1:
Add a name fact table
(You could use this formula add a new name table
Name = DISTINCT(UNION(VALUES(Table1[Name]),VALUES(Table2[Name] ))))
Step2:
Create a measure like this:
Measure = var _table=CALCULATETABLE(VALUES('Table1'[Name])) return CALCULATE(MAX('Name'[Name]),FILTER('Name',NOT('Name'[Name]) in _table))Step3:
Drag the name field from name table
and then drag the measure into visual level filter and set filter is not blank
Best Regards,
Lin
v-lili6-msft Just tried this and the result sets given isn't as expected. I'm recieving a result set of the deltas, but it's not being filtered properly in terms of the current slicers/filters applied. Also, when using MAX does that just look at the text string with the longest character in the result set?
hi, Anonymous
Use MAX just to create a measure to add it into visual level filter, and you should use name fact table as the result.
Please share your sample pbix file and expected output, and I will provide a solution for your specific report. You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.
Best Regards,
Lin
