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 only.      (NOTE:Data is sorted by Asenceing order) 

 

Below is the sample data and expected output.

 

Running Total           T or F

44.04                           True
77.2                             True
80.21                           True
80.31                           False
97.93                           False
98.96                           False
100                             False

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. 

3 Replies

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    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
    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.