Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have the following measure with existing filters....
Have you tried looking into KEEPFILTER instead of FILTER?
@Geeco1 ALL or REMOVEFILTERS should work. Not sure what field you are using in slicer. Can you please share sample data along with expected result to reproduce the scenario.
Using ALL gets close but not quite what I need. All of the data comes from a single table. The measures that I am using are
# of employees at the Beginning of a period
# of employees at the End of a period
# of Employees have terminated.
The page has 3 slicers (Type of Termination, Location, & Position) I want the measures that calculates the Beg and End employee count to ignore the Type of Termination slicer, but still use the Location and Position slicers. The Terminated employee measure should use all slicers.
When I used ALL in the Beginning and End measures, it would then also not let me use the Location or Position slicers.
I tried that one... however it then ignores ALL slicers. I only want the measure to ignore 1 slicer of the several on my page.
You could add additional parameters to calculate to ignore filters on specific columns:
User | Count |
---|---|
47 | |
26 | |
21 | |
17 | |
15 |
User | Count |
---|---|
53 | |
34 | |
17 | |
17 | |
15 |