Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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's avatar
Anonymous
Not applicable
5 years ago

Hi  Anonymous  ,

According to your description, I created the relationship:

Here are the steps you can follow：

1. Create measure.

Amount_1 = 
CALCULATE(SUM('transaction table'[Amount]),
FILTER('transaction table','transaction table'[Account ID]="GGGGGG"&&'transaction table'[Campaign ID]=MAX('transaction table'[Campaign ID])))

2. Result.

You can downloaded PBIX file from here.

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi, I have 1M different account ID, so I am hoping I can find a way to filter data automatically. Thanks for your response though.