calculate(countrows( "with a time"

[gmazza76]

Good afternoon,

I am trying to use current and past data to check call volumes between a set time frame and am having an issue as follows.

I can get the volumes from my data as per the DAX formula below per day, but I have now been asked to include a to and from time.
The formula from today is looking at the Monday of the current week which is great, but I am unsure how I would include the time part of the query.
My [Date] format is "13/12/2020 23:58:54" and I am unsure how to include the last part. I have seen time as "TIME(08,00,00)" but need some pointing in the right direction

=CALCULATE(COUNTROWS(Data),filter(Data,Data[CallType]=All_Data[CallType]),All_Data[Date]=today()-WEEKDAY(TODAY(),3))

thanks in advance
Gavin

 

[gmazza76]

I get the same error again with the formula above, but what is the difference wit the "calculate(countrows(" and "CALCULATE(COUNTROWS(All_Data),filter"

 

[RoryA]

Can you post your file somewhere and add a link here to it?

The syntax I posted works fine for me. (You don't need filter since calculate allows filters anyway)