Forum Discussion

Regular Visitor

3 years ago

Solved

DAX query behavior explanation

Hi, I have a table of dates and respective values associated with the dates: March 12, 2021: 22,393 unit sales March 13, 2021: 21,320 unit sales March 14, 2021: 21,927 unit sales March 15, 2021...

tamerj1
3 years ago
rido

When you place a column in a visual it acts as a filter. The subset of sales table that is visible in the first row is slready filtered to the date in the same row and so on. ALL removes the filter snd returns the complete table.

rido

Regular Visitor

3 years ago

Hello,
Thank you for the response 🙂

I can see that the updated formula returns the max value among all the dates for each date but I just wanted to understand why the original formula returned the values associated with the 2 dates only when the date field had been introduced.

tamerj1

Community Champion

3 years ago

rido

When you place a column in a visual it acts as a filter. The subset of sales table that is visible in the first row is slready filtered to the date in the same row and so on. ALL removes the filter snd returns the complete table.

rido
Regular Visitor
3 years ago
Yes, that seems like it.
Thanks a lot! 🙂