Forum Discussion
RBear
Advocate I
Advocate IHandling a one-off starting data point?
One frequently encounters situations where you start with a number and periodically increase and decrease it by certain other numbers. For example, population - increase by births, decrease by deaths...
v-frfei-msft
Community Support
Community SupportHi RBear,
We can create a measure as below to achieve your goal.
Measure = 100+ CALCULATE(SUM(Table1[Value]),ALLEXCEPT(Table1,Table1[Year]))
For more details, please check the pbix as attached.
Regards,
Frank
RBearAdvocate I
Advocate IAnd I just noticed that the measure itself doesn't work: the last column (Total Measure) should have the same values as the 2018 Measure column.