Forum Discussion
Slicer Selection
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
Community ChampionI like ThxAlot solution in DAX.
You could apply it to all measures by using a calculation group (configured via tabular editor). Just replace [val] with SELECTEDMEASURE(). Am away from a computer at the moment but can demo it later if you'd like.
Community ChampionSee 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