Forum Discussion

tnarenderr's avatar
tnarenderr
Frequent Visitor
3 years ago
Solved

Running total with condition

Hello All,   Am facing dificuties in wriign measure for the below scenario.   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 onl...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    3 years ago

    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.

  • tnarenderr's avatar
    tnarenderr
    3 years ago

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

tnarenderr's avatar
tnarenderr
Frequent Visitor
3 years ago

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

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    3 years ago

    Hi tnarenderr 

    Please try 

     

    Measure = 
var _min= minx(FILTER(ALL('Table'),[Running Total]>80),[Running Total])
return IF([Running Total]<=80 || [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.