Forum Discussion
Finding / Displaying Mismatch Between 2 Columns in Different Tables
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
v-lili6-msft i cannot share the PBIX file due to confidential data, and am unsure how to mask this largetset of data. I am esentially comparing Oil Rig Names between 2 tables. What i can say to paint a better picture is that visual 1 is a filtered result from a drill through, and visual 2 is a filtered result as well. These are filtered results from 2 different tables.
With that said, the problem I'm running into using your provided solution is that after creating the mapping table it is holding all the distinct rig names from table 1 and 2. When using the measure you provided it does help display the deltas between the two, but it is displaying the deltas for ALL the Oil rig names. I need the deltas to be from the 2 filtered visuals and not the entire list of rig names. I'm hoping this picture can help