Total Count Based on Slicer

[Anonymous]

Hi everyone this is my first go with Power Bi. Apologies for asking what probably amounts to a very simple question. Anyhow I've been asked to provide a report from our access card system which would show the # of days various employees came into the office. I have a slicer that allows the user to filter the starting and end dates.

What I can't figure out is how to create a measure / calculation that in this case would provide a value of 5 for building cleaning crew as an example with the date range filtered here as 5/1/23 - 5/5/23. 

[Anonymous]

Hi @amitchandak thank you for replying and my apologies as I didn't explain very well. There's another slicer which I'm not showing that allows for filtering based on our office locations.

So when you filter by office location(s) and date range you'll be presented with all the card activity during that time. What I need is a count of the # days during that range per each individual cardholder.

So here for example we see 4 different cardholders.

[amitchandak]

@Anonymous , Have slicer on date that will filter that (Or use date table joined with date and use that in filter)

You can have slicer for cleaning crew or have filter in measure

countrows(filter(Table, search("Cleaning", [Last, First],,0) >0 ) )

you can also consider distinctcount

calculate(distinctcount(Table[Last, First) ,filter(Table, search("Cleaning", [Last, First],,0) >0 ) )