DAX ALL using the date dimension
<p>Within Power BI Desktop (Version: 2.39.4526.362 64-bit (September 2016), I have written a DAX Statement that behaves differently when the column is sorted by another vs when it is not sorted by another.</p>

<p>Measure:</p>

<pre><code>Sum of Sales Across All Months =
CALCULATE ( SUM ( SalesAmount ), ALL ( 'Date'[MonthName] ) )
</code></pre>

<p>When the MonthName column is <em>unsorted</em> by another column, the measure behaves as I expect. Eliminating the filter context of the MonthName column. However, as soon as I set the MonthName column to be <em>sorted by another column</em> (e.g., MonthNumber) the "ALL" context reset is lost and it reverts back to the MonthName context.</p>

<p>Does anyone know if this is a bug or if I am misunderstanding something?</p>

<p>Thanks!</p>