Forum Discussion

POSPOS's avatar
POSPOS
Post Partisan
1 year ago

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...
Need Help
POSPOS's avatar
POSPOS
Post Partisan
1 year ago

lbendlin  - I tried to export data from the actual report and tried to replicate the issue. But the DAX you provided works fine in the sample file. I am trying to recreate a sample file with all the tables I have in the originial report and will share it. Thanks

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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!

  • POSPOS's avatar
    POSPOS
    Post Partisan
    1 year ago

    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.