DAX expression with 2 filters returning value

[Weatherreport]

Hi All,

I would need a DAX expression that would return "Avg Time" based on 2 filters "KDS Date=yesterday" and "Queue=K1":

In the sample above, the value to be returned should be "09:50".

Please note that "Avg Time" is a custom column and has been calculated as per below:

Thanks you so much

[amitchandak]

@Weatherreport , Create a measure like

calculate(sum(Table[Avergae Time]), filter(Table, [KDS Date]= today()-1 && [Queue]="K1"))

and convert to Min and second

[Weatherreport]

@amitchandak 

Thanks for your answer.

Yes that definitely solves half of my issues. But how can I convert that measure into Min and Second?