Forum Discussion
Exclude common values when joining two tables
Hi All, I have two tables with Row level security applied on the table 1 based on user. Table 1: I have Table 2 as below : Table 2: The requirement is to show all the divisions f...
Hi POSPOS ,
It's been a while since I heard back from you and I wanted to follow up. Have you had a chance to try the solutions that have been offered? If the issue has been resolved, can you mark the post as resolved? If you're still experiencing challenges, please feel free to let us know and we'll be happy to continue to help!
Looking forward to your reply!
Anonymous - Thank you for reaching out.
There were issues with the DAX as records with same data was showing up. As a workaround, we had to handle this differently by creating relationships between tables and then doing table2 difference table 1 with full data.