Showing results for 
Search instead for 
Did you mean: 
Helper V
Helper V

Show Daily Sales Last 4 weeks, ignore Year

Hi all,


I have a Calendar table, and a Sales Table connected by Date.


On a bar chart, I am showing Sales per day for last 4 weeks. I have Weeknum as Legend, Date as Axis and Sales as values.


However, when I use "Year" filter for 2021, it only shows for 2021, which makes sense.


Then I tried to do a measure: 


Sales Full = CALCULATE(SUM('Sales'[Sales EUR]),ALL(DimCalendar[Year]))
However, still shows for 2021, when I filter for Year = 2021.
Should't it ignore that?
Community Support
Community Support

Hi @PeterStuhr ,


I created a simple demo and didn't meet such situation.

Measure = CALCULATE(SUM('Table'[value]),ALL('Table (2)'[year]))




Can you show more details or share the pbix if you don't have any Confidential Information?


Best Regards,


Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
Super User IV
Super User IV

@PeterStuhr , When you use all and you have selected a year, All data will sum up to that year.

refer this video, it has been explained for months


As of now, the relative date slicer does not support the date. These case can be handled better with an independent date table


Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors