Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
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?
Solved! Go to 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
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
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?
User | Count |
---|---|
96 | |
85 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
96 | |
96 | |
67 | |
59 |