Forum Discussion
Solved
How to use FILTER with ALL?
I have a CALENDER table with LASTDAY column. On the page level I have applied filter: CALENDER[LASTDAY] is on or after 1/1/2021 I have a slicer on the page having all the months. What I want to d...
The format of your lastday column is incorrect. Should say
>= "2022-01-01"
Hi, Thanks for the response. Yes, page level filters are static and as mentioned above, I am trying to apply those manually to ALL():
_DefaultALL = COUNTX(FILTER(ALL(CALENDAR_DIM[LASTDAY]), CALENDAR_DIM[LASTDAY] >= 1/1/2022), CALENDAR_DIM[LASTDAY])
But somehow this filter CALENDAR_DIM[LASTDAY] >= 1/1/2022 is not getting applied.
How can we apply this?
Thanks.
