Running total with condition

Hi tnarenderr 

Thanks for reaching out to us.

>> If Running Total is <= 80 then True and in the range of 80.1 to 80.9 make it TRUE for the First occurrence record only.      (NOTE:Data is sorted by Asenceing order) 

you can try this measure,

Measure = 
var _min=CALCULATE(MIN('Table'[Running Total]),FILTER(ALL('Table'),'Table'[Running Total]>80))
return IF(MIN('Table'[Running Total])<=80 || MIN('Table'[Running Total])=_min,TRUE(),FALSE())

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Thanks for your response. how to rewrite measure if Running Total is also a measure.