Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Slicers without removing rows

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's avatar
    TeigeGao
    7 years ago

    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

2 Replies

  • TeigeGao's avatar
    TeigeGao
    Solution Sage
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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?