Accumulating Measure with a Startpoint (Constant Value in Measure)

[SC-THOLD-IT]

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:

Accumulation =

100000 +

CALCULATE(

    SUM(Zahlungsdaten_Formatiert[Betrag]),

    FILTER(

        CALCULATETABLE(

            SUMMARIZE(

                'Datumstabelle',

'Datumstabelle'[Date]

            ),

            ALLSELECTED('Datumstabelle')

        ),

        ISONORAFTER(

            'Datumstabelle'[Date], MIN('Datumstabelle'[Date]), DESC

        )

    )

)

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.

[amitchandak · Accepted solution]

@SC-THOLD-IT ,

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))

[SC-THOLD-IT]

Wow, Thank you very much.

Have a great day!