Please help me with this one
I have a dataset that contains customers participating in campaigns.
As this is a many-to-many relationship I have a bridge table in between customers table and campaign table.
I would like to use slicers BOTH to include and exclude customers that have participated in various campaign. Select customers that are IN some campaign but NOT IN and other one
I have so connected the tables this way
VALOS_UP_ID is the customer ID
KAMPANY_ID is the campaign ID
KAMPANY_NEV is the name of the campaign whatsoever
KAMPANY table is the one I would like to use for SELECT (include)
KAMPANY_KIZARO table is the one I would like to use for !SELECT (exclude)
Is there a way to do this in Power BI DAX functions?
I have been looking at this topic but I could not get my head around it as it uses no bridge tables
Thanks in advance
