Forum Discussion
Time Filter Not Working
Hi, In another thread , Creating Time Filter, I was looking for a solution to filter First Response Time (Mins) according to create date I wanted to know the average First response time (mins) ...
anusornkhurana , Avg at what level
Example at hour level
Sumx( Values('Table'[Hour]),
CALCULATE(SUM('Table'[First Response (Minute)]),FILTER('Table', 'Table'[Create Time]<=TIME(17,00,00) && 'Table'[Create Time]>=TIME(8,00,00)))
)
At the hour level
average of first response (mins) that occured to all tasks created [Create Time] between 8.00-17.00
I tried the measure you gave me it didn't work. It is still returning Blank value 😞
Thank you!