How to create slicer for dates and not affect other charts

Question

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.&nbsp;columns: tech name | Closed last business day | Closed in last 30 days&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; John smith&nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;60I was able to create a column with this:&nbsp;Closed last business day = IF(DATEDIFF('Support PowerBI Closed Cases'[Date/Time Closed], TODAY(), DAY) &lt; 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&nbsp;How woulod i be able to do this, would it be a measure or would can i use other filtering methods with date slicers?

v-jingzhang · Accepted Answer

Hi&nbsp;Anonymous&nbsp;
&nbsp;
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.&nbsp;

&nbsp;
Then create the following measures with the date column. Put them in a table visual along with Tech name column.&nbsp;
Closed last business day = CALCULATE(COUNT('Table'[Ticket]),ALL('Table'[Date Closed]),'Table'[Date Closed] = TODAY()-1) + 0Closed in last 30 days = CALCULATE(COUNT('Table'[Ticket]),ALL('Table'[Date Closed]),'Table'[Date Closed] &lt; TODAY(),'Table'[Date Closed] &gt;= TODAY()-30) + 0

&nbsp;
Best Regards, Community Support Team _ JingIf this post helps, please Accept it as Solution to help other members find it.

Forum Discussion

Related content

Slicer panels affecting bookmarks

Slicer affected by other slicer

CALCULATE with REMOVEFILTERS still affected by slicer

Make visual affect slicer

Slicer affecting measure