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:
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?
@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
Proud to be a Super User!
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.