How to create slicer for dates and not affect other charts

[Anonymous]

My end goal is to have a table that will count the amount of closed cases/tickets within the last 24 hours and 30 days based off each tech. 
columns: tech name | Closed last business day | Closed in last 30 days 

          John smith      |     5                                  |         60
I was able to create a column with this: 

Closed last business day = IF(DATEDIFF('Support PowerBI Closed Cases'[Date/Time Closed], TODAY(), DAY) < 1,"True","False")
Which works, and when I add them to a table, i select count and it gives me the total for the entire spreadsheet, I would like it to show me the last 24 hours and last 30 days 

How woulod i be able to do this, would it be a measure or would can i use other filtering methods with date slicers?

[Anonymous]

This is excellent! Thank you for the help!!

[v-jingzhang · Accepted solution]

Hi @Anonymous 

You can add a "Date Closed" column with only dates from "Date/Time Closed", and change this new column to Date type. You can also change "Date/Time Closed" column to Date type if you don't need its timestamp values later. 

Then create the following measures with the date column. Put them in a table visual along with Tech name column. 

Closed last business day = CALCULATE(COUNT('Table'[Ticket]),ALL('Table'[Date Closed]),'Table'[Date Closed] = TODAY()-1) + 0

Closed in last 30 days = CALCULATE(COUNT('Table'[Ticket]),ALL('Table'[Date Closed]),'Table'[Date Closed] < TODAY(),'Table'[Date Closed] >= TODAY()-30) + 0

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.