Forum Discussion
Sum previous year
Hi, that's my graph: With the blue line (that's a simply distinct count) i need to sum the previous year to the current year. So, it will become: 2014: 819 2015: 2412 + (819) 201...
Anonymous
try a measure
Measure = CALCULATE(SUM('Table'[Codici]),FILTER(ALL('Table'),'Table'[Year]<=MAX('Table'[Year])))
Hi,
it should be count as 2!
Thanks
Anonymous
try a measure
Measure = CALCULATE(SUM('Table'[Codici]),FILTER(ALL('Table'),'Table'[Year]<=MAX('Table'[Year])))Am i missing something?
This is the problem
in the measure ALL is a problem
I will try with allexcept
Ok thanks it works with some correction in the filter, thanks!
I got the desired values with the above solution . Now when i am putting legends the graph is showing same values
Please if you have any solution on this