topic Re: Sum of hrs with filter condition in DAX Commands and Tips

Sum of hrs with filter condition

Anonymous — Thu, 20 Jan 2022 12:51:40 GMT

I want to sum StandByBeforeJobTime (hr) greater than 24
The below graph should show only values if StandByBeforeJobTime (hr) is greater than 24

how to add this condition
these are the below dax which are used
StandByBeforeJobTime := DATEDIFF([ArrivedOnLocationTime],[RightUpTime],HOUR)
ArrivedOnLocationTime := Calculate( MIN(Event[event_date]),Event[event] = "Arivved on location"))
RightUpTime := Calculate( MIN(Event[event_date]),Event[event] = "Run Safety Briefing"))

If it was possible to create calculated column for StandByBeforeJobTime then
I would have just use Calculate(sum(StandByBeforeJobTime),StandByBeforeJobTime>24))
But I have used 2 different measures to find the hours

this is also not working

measure = IF([StandByBeforeJobTime]>24,[StandByBeforeJobTime])

Re: Sum of hrs with filter condition

ValtteriN — Thu, 20 Jan 2022 13:02:07 GMT

Hi,

You can create a "filter measure" and apply that to your visual.
E.g. Filter measure = IF([StandByBeforeJobTime]>24,1,0)

Now place it on your visual like this:

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

Re: Sum of hrs with filter condition

Anonymous — Fri, 21 Jan 2022 17:13:39 GMT

It's not working

Re: Sum of hrs with filter condition

ValtteriN — Fri, 21 Jan 2022 17:38:25 GMT

Hi,

Could you elaborate what the issue is? Here is a more detailed example:

Data:

Dax:

Filter measure jobs = IF(SUM(Jobtime[Jobtime])>20,1,0)

End result: