Forum Discussion
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 following:
The Line-Chart start at the Value 100.000 as i intended, but my Date-Slicer wont filter the Line-Charts Date Axis (X-Axis) anymore.
Or even further, the datevalues in the future have the consttant value of 100.000, also the Forecasting wont work:
What is the correct way for a measure with a constant starting point for accumulations.
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))
2 Replies
- amitchandak
Super User
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))