Forum Discussion

POSPOS's avatar
POSPOS
Icon for Post Partisan rankPost 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
Icon for Post Partisan rankPost Partisan
1 year ago

lbendlin  - thank you for your response. I tried to implement the same DAX in the actual report and it does not emilimate the same records from the table. Please find details below :

Can you please suggest

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

  • POSPOS's avatar
    POSPOS
    Icon for Post Partisan rankPost 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
        Icon for Post Partisan rankPost 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.