Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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 be time type (Full time, part time, per diem) and by termination type (voluntary, involuntary). I have these as slicers on my page.
The calculation is terminations (count is affected by filters above) divided by the average of (the beginning of the period [e.g., Nov 1] and the end of the period [e.g., Nov 30]).
The begining of the period (BoP) is affected by the filter, so I had to add a DAX clause to ignore the filter - has to do with how the data is store; the same is true for the end of the period (EoP). I finally got those to be appropriately unaffected by the slicer filter. When I drop in my terminations measure, it does not change with the slicer filter. When I put that same measure in a different visual on the same page, it filters just fine. So, I believe the problem lies in how I got my BoP and EoP to ignore the filter.
Here is the language for the BoP:
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])
)
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.
User | Count |
---|---|
114 | |
73 | |
57 | |
47 | |
38 |
User | Count |
---|---|
168 | |
120 | |
60 | |
58 | |
53 |