topic Re: New measure to count any event over 24 hours in DAX Commands and Tips

New measure to count any event over 24 hours

zurimae — Mon, 20 Feb 2023 15:13:04 GMT

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.

Re: New measure to count any event over 24 hours

tamerj1 — Mon, 20 Feb 2023 15:23:16 GMT

Hi zurimae

what are slicing by in this visual?

Re: New measure to count any event over 24 hours

zurimae — Mon, 20 Feb 2023 15:27:07 GMT

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

Re: New measure to count any event over 24 hours

FreemanZ — Mon, 20 Feb 2023 15:59:14 GMT

hi zurimae

try like:

Count =

COUNTROWS(

FILTER(

TableName,

TableName[ColumnName]>=24

)

Re: New measure to count any event over 24 hours

zurimae — Mon, 20 Feb 2023 16:56:32 GMT

that worked! thank you so much!