Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Accumulating Measure with a Startpoint (Constant Value in Measure)

Hello everyone,   I have this problem with accumulating Values as a Line-Chart. I want a starting point (like for example 100.000) from where its start to add up (or go down). I did the followin...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous ,

     

     

    add 100 force remove range example  , assume you have measure Accumulation  without adding 100


    Measure = var _1= [Accumulation]+100
    var _min = minx(ALLSELECTED('Calendar'), 'Calendar'[Date])
    var _max = maxx(ALLSELECTED('Calendar'), 'Calendar'[Date])
    return
    CALCULATE(if(max('Calendar'[Date]) <_min || max('Calendar'[Date]) >_max , BLANK(), _1))

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous ,

 

 

add 100 force remove range example  , assume you have measure Accumulation  without adding 100


Measure = var _1= [Accumulation]+100
var _min = minx(ALLSELECTED('Calendar'), 'Calendar'[Date])
var _max = maxx(ALLSELECTED('Calendar'), 'Calendar'[Date])
return
CALCULATE(if(max('Calendar'[Date]) <_min || max('Calendar'[Date]) >_max , BLANK(), _1))

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Wow, Thank you very much.

    Have a great day!