topic Re: Counting time values that is more than 00:00:05 in DAX Commands and Tips

Counting time values that is more than 00:00:05

Anonymous — Tue, 13 Oct 2020 07:46:27 GMT

Good Morning,

I am new to DAX and am struggling to find the formula for this. What I want to do it count anything in a coloumn that is greater than 00:00:05 seconds.

Attached is a picture of the collumn I need to calculate, sorry I cant show you more as this is sensitive data.

Any comments are welcome

Kind Regards,

Sam

Re: Counting time values that is more than 00:00:05

wdx223_Daniel — Tue, 13 Oct 2020 08:08:41 GMT

CALCULATE('TABLE'[COL],'TABLE'[COL]>=TIMEVALUE("00:00:05"))

some adjustments should be needed according to your model

Re: Counting time values that is more than 00:00:05

themistoklis — Tue, 13 Oct 2020 08:37:41 GMT

Anonymous

You can try the following formulas

Measure1 = CALCULATE(COUNT('SHEET1'[ID]),FILTER('SHEET1'[TIMEFIELD]>=TIME(0,0,5))) Measure2 = CALCULATE(COUNT('SHEET1'[ID]),FILTER('SHEET1'[DATEFIELD]>=DATE(2020,10,12), 'SHEET1'[TIMEFIELD]>=TIME(0,0,5)))

Re: Counting time values that is more than 00:00:05

Anonymous — Tue, 13 Oct 2020 08:43:18 GMT

wdx223_Daniel

Sorry, would this be a measure of an added column?

Re: Counting time values that is more than 00:00:05

Anonymous — Tue, 13 Oct 2020 08:44:49 GMT

themistoklis

The first measure gave me these results

Re: Counting time values that is more than 00:00:05

Anonymous — Tue, 13 Oct 2020 08:48:51 GMT

themistoklis

The second measure is erroring giving me the following message:

Sorry for being a pain

Regards,

Sam

Re: Counting time values that is more than 00:00:05

themistoklis — Tue, 13 Oct 2020 08:56:09 GMT

Anonymous

You forgot a comma between DATE(2020,01,01) , (and before eCRSStat)

Re: Counting time values that is more than 00:00:05

Anonymous — Tue, 13 Oct 2020 08:57:01 GMT

themistoklis

With the comma it is still returning an error

Re: Counting time values that is more than 00:00:05

themistoklis — Tue, 13 Oct 2020 09:18:45 GMT

Sorry Anonymous

Please replace comma with && (2 ampersand)

Re: Counting time values that is more than 00:00:05

amitchandak — Tue, 13 Oct 2020 10:43:55 GMT

Anonymous , A new column

If(Table[col] >time(0,0,5),1,0)