topic Re: How to count all rows that contain a specific time value and above in DAX Commands and Tips

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

am_i_really — Thu, 22 Dec 2022 15:52:08 GMT

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!

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

FreemanZ — Thu, 22 Dec 2022 16:06:09 GMT

hi am_i_really

try like:

Measure =

COUNTROWS(

FILTER(

ALL(Master),

Master[Order Time] <= 11/24

)

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

am_i_really — Thu, 22 Dec 2022 16:10:35 GMT

Thank you, worked like a charm!

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

AlexisOlson — Thu, 22 Dec 2022 19:52:19 GMT

Another method:

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