I am developing a model to simulate the cost of coverage increases by 20% per year for 7 groups.
I am using a hierarchy slicer to enable the end users to select the group and start year (2019-2025) for the scale-up assuming a 20% coverage increase every year maxing out at year 5.
I want to create a measure to calculate a cumulative cost total.
My current measures are:
20% Implementation =
SUMX(MASTER, [Total cost]*.2)
Cumulative Total by year =
CALCULATE([20% Implementation], FILTER(ALLSELECTED(MASTER), MASTER[Year]<= MAX(MASTER[Year])))
Cumulative Total by Year MAX =
IF ([Cum Total by year] < [Total cost], [Total cost], [Cum Total by year])
Measure 2 is calculating the amount for the year even when it is not selected, but when any other year for the group is. Any ideas on how I can adjust this measure to account for the year sub-selection?
Thanks much. Robert