Forum Discussion
Adding a Slicer to Many to Many Table
Hi everyone, I have a campaign member table like this: Campaign ID Name Year Status Account ID XXXXX A 2017 New GGGGGG XXXXX B 2017 2 Years YYYYYY YYYYY A 2018 New GG...
Thanks Tim. I am still verifying numbers with my report, but I think I found a solution. I created a conc column (campaign ID & account ID) for both my campaign member table and transaction table. I also created a bridge table with unique conc from both tables. Then, I linked relationships based on conc, not campaign id. It works in my example table, but hoping this solves my issue. I appreciate your help.
Anonymous
1. Create one table having unique value of Campaign ID
Table3 = DISTINCT(UNION(DISTINCT(Table1[Campaign ID]),DISTINCT(Table2[Campaign ID])))
2. Then create relationship between tables like below
3. You can create your visual like below
You can refer to my file as well.
Hi, thanks for your response. My ideal result is $100 for campaign XXXX when "new" is filtered.