Forum Discussion
POSPOS
Post Partisan
Post PartisanExclude 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...
lbendlin
Super User
Super User
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')
POSPOSlbendlin - 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
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.