Slicers without removing rows

[Anonymous]

I have a table showing the events attended by individuals. I want to use the Event Type slicer to change only the values in the table, not the number of rows (count of members). Is it possible to use a slicer without changing the number of rows in a table while still changing the values in the table?

Without filter
With filter

Above, you can see that when the filter is selected, it filters out anyone who hasn't been to a DC event (about 15 people). I dont want those 15 removed, I just want their values in the table to become blank/0. Any tips?

[TeigeGao · Accepted solution]

Hi @Anonymous ,

In your scenario, we can create a Event Type table without relationship between the fact table, then use the calculate (***,filter(all([Event Type]), *** = allselected([Event Type])))

Best Regards,

Teige

[Anonymous]

I'm not sure I understand.

I create a new table with the event types and then create a measure with (***,filter(all([Event Type]), *** = allselected([Event Type]))).

And then doing that I can create a slicer that will adjust the counts?