Forum Discussion
Slicer Select all option while excluding one value
You can't make a slicer default to only certain values when you click Select All.
However you could build the logic into a measure:Sum Of Amount (Special Slicer) = IF ( ISFILTERED ( Sales[Item Type] ), SUM ( Sales[Amount] ), CALCULATE ( SUM (Sales[Amount] ), Sales[Item Type] <> "Maintenance" ) )bcdobbs I just downloaded your file and it's working however when i applied to my report it is not. Logic is solid and makes sense not sure why but it is not working on my end.
Here is the code i am using.Special Slicer TY = IF ( ISFILTERED ( 'POS CY'[Slicer]), [POS TY], CALCULATE ( [POS TY], 'POS CY'[Slicer] <> "Maintenance" ) )
You can't make a slicer default to only certain values when you click Select All.
However you could build the logic into a measure:
Sum Of Amount (Special Slicer) =
IF (
ISFILTERED ( Sales[Item Type] ),
SUM ( Sales[Amount] ),
CALCULATE (
SUM (Sales[Amount] ),
Sales[Item Type] <> "Maintenance"
)
)bcdobbs Thanks for your reply. If i exclude maintenance in the measure and select maintenance from slicer it will return blank value. I want to have option to be able to select Maintenance and total without maintenance.
Thanks
No, in the measure there's an IF statement that tests whether there is a filter on the column.
If there is it returns the sum you'd expect. It only excludes when everything is selected.