Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (17.6k points)

Hello, here is my dataset :

enter image description here

What I would like to have is a filter on Campagne which shows all the other Campagne if the Contract number is the same. I explain myself. If I click on Campagne 3 in my filter, I want to see 1, 2, 3 and the attribution (the attribution by Campagne, not a Sum). Here is the expected result :

enter image description here

For now, the only solution that I have is to use a "temporary" table. But it's not optimal because I have to duplicate the data.

Any idea?

1 Answer

0 votes
by (47.2k points)
  • We have to create an extra table or two to get the slicer to work how you want. There's no way around it, but you only need to duplicate part of the data. Here's what I would suggest.

  • Create a new Slicer table by summarizing the Campagne and Contrat columns from your original table.

Slicer = SUMMARIZE(Table1, Table1[Campagne], Table1[Contrat])

  • Now since you want the filtering to be done by Contrat and this would require a many-to-many relationship with the original table, you need to create a bridge table.

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...