Values in Hierarchy Level

[greenlover]

Hi everyone, 

Would like to ask for your help. I have a trend visual using a date dimension (hierarchy - year, qtr, month, day) 

With the view below (Monthly view from 2016 to 2022) values are correct. 

However, if I drill up to yearly view, 2016 to 2022, the values are commulative. Is it possible to just get the count of December and the latest month?

Expectation:

Last month of the year (december) and latest month will be displayed when the view is yearly.

Hope you could help if this is possible 🙂 

Thank you!

[amitchandak]

@greenlover , Can you share the meausre you ?

you should have a measue like this for rolling

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[Date])))