Count number of unselected names in a slicer based on date slider

[dkm]

@amitchandak

@Greg_Deckler 

Hello. I have a chiclet slicer with a list of patient names and a date slicer/slider. When I change the date range with the date slicer (dates of appointments), the number of patient names listed in the chiclet slicer changes accordingly (i.e. total number of unselected patient names listed is 2,420 and when the date slicer is changed, the total number of unselected patient names listed in the chiclet slicer is 42). I would like the count of customers listed in the chiclet slicer to be shown in a card each time a date range is changed in the date slicer without having to select any customer names.

What it looks like before I change the date slider:

What I need it to look like after the date slider is changed:

[v-henryk-mstf]

Hi @dkm ,

Whether the advice given by @amitchandak  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Looking forward to your feedback.

Best Regards,
Henry

[amitchandak · Accepted solution]

@dkm , if the name and date are coming from the same table or related table then the count should change

other wise you can force filter like

new measure =
var _max = maxx(allselected(Date),Date[Date])
var _min = minx(allselected(Date),Date[Date])
return
calculate( sum(Table[Value]), filter('Table', 'Table'[Date] >=_min && 'Table'[Date] <=_max

&& Table[patient names] in values(patient[patient names])))

[dkm]

Many thanks to you!