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 ChampionHi 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
- PaulDBrown
Hi 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