Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

DAX expression with 2 filters returning value

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

Super User IV
Super User IV

@Weatherreport , Create a measure like

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


and convert to Min and second

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!


Thanks for your answer.

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



Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates