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 INow that I have tried your measure - close, but no cigar :(
First, Measure appears in the report as a column - that won't work because (i) it presents the same information in all rows, which is superflous and (ii) it has to be presented as a row. The second issue can be resolved by going to the formatting options of a Matrix. Format > Values > Show on rows > On
That options is better, but results in this:
I don't know how to suppress the first two rows displaying Measure, such that only the bold, bottom row appears. The final version should look like this: