Show Daily Sales Last 4 weeks, ignore Year

[PeterStuhr]

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!

[v-jayw-msft]

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,

Jay

[amitchandak]

@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