Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
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
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers

500 comments

94k users

Browse Categories

...