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
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