Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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])
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!
Proud to be a Super User!
It's not working
Hi,
Could you elaborate what the issue is? Here is a more detailed example:
Data:
Dax:
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |