Dax filter on time

[sanket_sk]

Hi Everyone,

Hope all are doing fine!!!

I'm working on a Power BI desktop, where I want to filter closed cases within 5 minutes, so I want to apply the filter to the column "Time Duration", but it looks like I'm missing something, this query doesn't give the expected result, can you please help me complete this query.

Filtering Column = Time Duration
Column Data Type = Duration

5 Mins Cases = CALCULATE(COUNTROWS(Closed_Calls),FILTER(Closed_Calls,Closed_Calls[Time Duration]<=0.05))

Thanks in Advance.

Sanket

 

[Matt Allington]

Hi Everyone,

Hope all are doing fine!!!

I'm working on a Power BI desktop, where I want to filter closed cases within 5 minutes, so I want to apply the filter to the column "Time Duration", but it looks like I'm missing something, this query doesn't give the expected result, can you please help me complete this query.

Filtering Column = Time Duration
Column Data Type = Duration

5 Mins Cases = CALCULATE(COUNTROWS(Closed_Calls),FILTER(Closed_Calls,Closed_Calls[Time Duration]<=0.05))

Thanks in Advance.

Sanket

You need to use the time() function, not a decimal number

 

[sanket_sk]

You need to use the time() function, not a decimal number

Hi There ,

Thanks a lot for suggestion, could you pls help me with formula.


Sanket