How to count all rows that contain a specific time value and above

[am_i_really]

Hi All,

I'm trying to write a measure that would allow me to count all the rows in a column that contain "11:00:00 AM" or any time before that. Table name is Master and column name is Order Time. 

Thank you in advance!

@po 

[AlexisOlson]

Another method:

CALCULATE (
    COUNT ( Orders[Order Time] ),
    Orders[Order Time] <= TIME ( 11, 0, 0 )
)

[FreemanZ · Accepted solution]

hi @am_i_really 

try like:

Measure =

COUNTROWS(

   FILTER(

      ALL(Master),

      Master[Order Time] <= 11/24

    )

)

[am_i_really]

Thank you, worked like a charm!