Sum of hrs with filter condition

[Anonymous]

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])

[ValtteriN]

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!

[Anonymous]

It's not working

[ValtteriN]

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: