topic Re: DAX expression with 2 filters returning value in DAX Commands and Tips

DAX expression with 2 filters returning value

Weatherreport — Thu, 03 Jun 2021 03:02:26 GMT

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 — Thu, 03 Jun 2021 06:29:06 GMT

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 — Thu, 03 Jun 2021 07:48:27 GMT

Thanks for your answer.

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