Forum Discussion
Slicer Selection
Hello everybory, I hope you are doing well. I have a simple question, and I would like your help. I need to create a different slicer filter here, and I do not know how to handle it. The followi...
See what you make of this:
There is a calculation group configured via tabular editor:
----------------------------------------------------------- -- Calculation Group: 'Province Selection Calulation Group' ----------------------------------------------------------- CALCULATIONGROUP 'Province Selection Calulation Group'[Name] Precedence = 1 CALCULATIONITEM "Select Provinces" = VAR MinIndex = MIN ( Province[Index] ) RETURN CALCULATE( SELECTEDMEASURE(), REMOVEFILTERS( Province[Povince] ), Province[Index] >= MinIndex )Basically the same measure but you don't need the calcualted table bit.
Then you just drop the calculation group into the visual level filter pane:
This article explains more on creating them using tabular editor:
Introducing Calculation Groups - SQLBI
I think the easiest way would be to use a bridge table with two columns:
Province Selection, Included
A, A
A, B
A, C
A, D
B, B
B, C
B, D
C, C
C, D
D, D
Then create a many to many relationship with filter in one direction from it to the City Table.