Get SUM of compound rate calculation with numeric field
Hi all, please see below one example data set: Year Value FC-Flag 2010 23 2011 43 2012 23 2013 45 2014 67 2015 54 2016 54 1 2017 54 1 2018 54 1 2019 54 1 2020 54 1 2021 54 1 2022 54 1 2023 54 1 With that data i do calculate firstly a measure that displays only the Forecast Values: FC = CALCULATE(SUM(Tabelle1[Wert]),NOT ISBLANK(Tabelle1[Flag])) That measure i use to calculate the actual compound interest values in combination with a Numeric Range user input (Index Value): Wage Indexed = VAR selectedyear = SELECTEDVALUE('Date'[Year]) VAR currentyear = 2015 // this might need to be calculated VAR rate = DIVIDE([Index Value],100) RETURN [Wages] * POWER((1 + rate),selectedyear-currentyear) Thats works fine for displaying the values in a table/chart and the values are calculated as expected. However when I try to get the sum over the years this measure returns 0 - and i didn't manage to adjust the query to also return a sum over the years. Example screenshot: I'm trying to get the SUM for the values in each year in the Total(Gesamt) column. As you can see currently, it doesn't work like that. Would appreciate any help/idea how to get the sum in combination with calculating the compound interest with a numeric field (user input). Thanks
