Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
@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)))
The second measure is erroring giving me the following message:
Sorry for being a pain
Regards,
Sam
@Anonymous
You forgot a comma between DATE(2020,01,01) , (and before eCRSStat)
Sorry @Anonymous
Please replace comma with && (2 ampersand)
CALCULATE('TABLE'[COL],'TABLE'[COL]>=TIMEVALUE("00:00:05"))
some adjustments should be needed according to your model
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
26 | |
17 | |
12 | |
12 | |
10 |
User | Count |
---|---|
33 | |
25 | |
16 | |
14 | |
13 |