Forum Discussion

Decal's avatar
Decal
Helper I
2 years ago

Slicer Not Affecting Measure

I've read a lot of articles out there on this, and just can't seem to find a solution.   This is what I'm doing.  I am calculating an employee attrition rate.  My users want to be able to slice it ...
Need Help
Sahir_Maharaj's avatar
Sahir_Maharaj
Super User
2 years ago

Hello Decal,

 

Can you please try this:

Terminations (All Selected) =
VAR _bop = MIN(dimDate[Date])
VAR _eop = MAX(dimDate[Date])
RETURN
CALCULATE(
    [Terminations (Dynamic)],
    ALLSELECTED(dimDate),
    ALLSELECTED(dimWorker[CF EE Termination Voluntary/Involuntary]),
    ALLSELECTED(dimWorker[Time Type])
)
Decal's avatar
Decal
Helper I
2 years ago

I appreciate the attempt, but unfortunately that did not work.   The number should have moved from where it is a 22 for my sample month to 19.  Instead it moved up to to 74.