Forum Discussion
Solved
Related filtering with years
Hi everyone, I hope u can help me with this. These are my two tables. Sales ant Time and I have a measure that is: TotSales = CALCULATE(
SUM(Sales[SalesAmount...
The following measure should work:
OriginSales =
VAR SlicerYear =
SELECTEDVALUE ( CalendarTable[Year] )
RETURN
CALCULATE ( [TotSales], SalesTable[Origin Year] = SlicerYear )We create a variable called SlicerYear that stores the current value from the slicer.
We then modify the filter context by using CALCULATE(), and specify that we want SalesTable[OriginYear] to equal the stored SlicerYear value.
All the best,
~ Chris H
Hi,
I do not get it. How did 13,061 comes about. Does number 4 represent January?
Hi Ashish_Mathur Anonymous
Sorry for mistake this is what i get when select Jan 2017
Finally i could get the value.
Thanks a lot !