cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PeterStuhr
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?
 
Thanks!
2 REPLIES 2
v-jayw-msft
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]))

1.PNG

2.PNG

3.PNG

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

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
amitchandak
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

https://www.youtube.com/watch?v=duMSovyosXE

 

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

Announcements
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!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors