Forum Discussion
Community ChampionMinimum Date: ALL does not ignore date filter context
Hi all,
Just to help if anyone is experiencing this same problem, I have found a solution by reading the following article by Alberto Ferrari on sqlbi.com:
Apprently I needed to add CALCULATETABLE to the filter in order to obtain the first date regardless of the date filter in the matrix.
I obviously still have a long way to go to understand the ALL function...
Community SupportHi PaulDBrown
Some references for you to learn ALL function further.
Video: How to Use The ALL function in Power BI & DAX
This article provides a complete explanation of the behavior of the ALLxxx functions in DAX. When used as filters in CALCULATE, ALLxxx functions might display unexpected behaviors.
Best Regards
Maggie
Community ChampionHi Maggie,
Thank you very much for providing the resources, I'll take a deep dive and hope to get a better understanding of how ALL works,
Best regards,
Paul