Forum Discussion
Helper IIwhat values is doing in Calculate
It looks like the author is expecting, or at least allowing for, a slicer or filter to be placed on the days of the week. VALUES will return only those days which are selected, so those days will be added to the filter context.
The reason that they needed to add that, rather than just allowing the filter to take effect, is that when you have a table marked as a date table and you then apply a filter to the date column, all other filters on the date table are automatically removed, at least that is my understanding.
Super UserIt looks like the author is expecting, or at least allowing for, a slicer or filter to be placed on the days of the week. VALUES will return only those days which are selected, so those days will be added to the filter context.
The reason that they needed to add that, rather than just allowing the filter to take effect, is that when you have a table marked as a date table and you then apply a filter to the date column, all other filters on the date table are automatically removed, at least that is my understanding.