Forum Discussion
Exclude common values when joining two tables
I would strongly recommend you do all this further upstream. With RLS involved performance will be a critical factor, but the data is immutable so there is no reason to do this in DAX.
If you insist -
Table 3 = EXCEPT (
SELECTCOLUMNS(
SUMMARIZECOLUMNS(
'Table 1'[User],
'Table 2'[Dept],
'Table 2'[Div],
"CountRowsTable_2", COUNTROWS('Table 2')
),
[User],
[Dept],
[Div]
)
,'Table 1')
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
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.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
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!