Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. 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.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 53 | |
| 45 | |
| 44 | |
| 20 | |
| 19 |
| User | Count |
|---|---|
| 73 | |
| 71 | |
| 34 | |
| 33 | |
| 31 |