Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
18 |