I’m currently watching the modules about Time Intelligence Functions, but there is one thing that I cannot explain for myself. It is regarding the video: " Compare Current Sales To Previous Best Month ".
In that video we use the following DAX formula:
Highest Previous Sales Mth =
CALCULATE( [Total Sales];
FILTER( SUMMARIZE( ALL( Dates ); Dates[Month & Year]; Dates[MonthnYear]);
Dates[MonthnYear] <= MIN( Dates[MonthnYear] ) );
[Total Sales]; DESC ) )
In this formula we remove all the context from the Dates table. However, if I use the slicer for the dates, the “Highest Previous Sales Month” only looks at months that are within that slicer.
Let me explain. On Jan 2015 we got Total Sales of 1.024.700. So if you set the slicer for Date 1-1-2015 till whatever, you get Highest Previous Sales Mnth is 1.024.700 until July 2015.
However, if we slice the Date table from 1-1-2015 to 1-3-2015 (so March), the Highest Previous Sales Mnth is 614.899.
I simply don’t get it why this formula still listens to the context as provided by the slicer as ALL should remove everything right?
Hope someone can help me