Slicer to select Boolean values equal 1 or ALL but not 0

[andybrace]

I have a column in my data set that is boolean values.  I need a filter where the user has 2 options, these are either

1) Select ALL values

2) Select boolean values = 1

There is never a scenario they would select just 0's.

I want to make it super user friendly and no need to understand that underlying data.  So, they would just have 2 options "Yes"=ALL, "No"=1.

The only way I can think is to have a toggle switch with bookmarks attached.  However, we already have A LOT of bookmarks and I think this will make it too complicated.  I was hoping there was an option using a slicer somehow as many of our other report settings are through slicers.

Anyone have any ideas how to accomplish this using a slicer?

[andybrace]

Thanks!  This works well

[amitchandak · Accepted solution]

@andybrace , Create a independent table with

Yes

No

or

All

1

Then create a measure like

Switch(selectedvalues(Table[column]),

"Yes", sum(fact[Value]),

calculate(sum(fact[Value]),filter(fact, fact[column]=1))

)