Forum Discussion
Ignoring outside slicers
I work for a retailer and have built a report with products on the rows and some attributes and measures.
1. One of the measures is this one that simply sums the sold quantity the last 30 days.
Quantity R30d = CALCULATE([Quantity], DATESBETWEEN('DateTable'[Date],today()-30,today()-1))
This measure is then used to calculate how much the current stock will last until depleted.
2. However, I also have a measure that shows the sales and this measure is dependent on a Date slicer from DateTable above. This way the user can chose the most appropiate time period for this.
The problem is then that changing the date interval also changes the first measure (1).
I want the the first measure to calculate the sold quantity during the last 30 days regardless of the date interval.
I know that All and AllExcept could be used in similar situations but it doesn't work in this case since I don't want 1 to ignore DateTable[Dates], only the Date interval slicer.
Is it posible to add to my measure that it should not take the "outside" slicers into account?
Best regards,
E
1 Reply
- Fowmy
Super User
Anonymous
Generally, you can use two dates table for this task.
