New measure to count any event over 24 hours

[zurimae]

Hi, i need to create a measure that will give me a count of any time over 24 hours.  For example these are in hours. as you can see only one is >24hours, but i need a measure that will count this. 

[FreemanZ · Accepted solution]

hi @zurimae

try like:

Count =

COUNTROWS(

    FILTER(

        TableName,

        TableName[ColumnName]>=24

    )

)

[zurimae]

that worked! thank you so much!

[tamerj1]

Hi @zurimae 

what are slicing by in this visual?

[zurimae]

what do you mean slicing by? this is hours of start to end. the formula is putting hours/min into decimals to calculate easier.