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

[Anonymous]

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

[amitchandak]

@Anonymous , A new column

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

[themistoklis]

@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)))

[Anonymous]

@themistoklis 

The second measure is erroring giving me the following message:

Sorry for being a pain 

Regards,

Sam

[themistoklis]

@Anonymous 

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

[Anonymous]

@themistoklis 

With the comma it is still returning an error 

[themistoklis]

Sorry @Anonymous 

Please replace comma with &&  (2 ampersand) 

[Anonymous]

@themistoklis 

The first measure gave me these results

[wdx223_Daniel]

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

some adjustments should be needed according to your model

[Anonymous]

@wdx223_Daniel  

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