Forum Discussion
Solved
Removing filter date context
Hi everyone, how can I remove the filter context having a date slicer? thanks in advance đŸ™‚
Vacant Properties =
CALCULATE (
DISTINCTCOUNT ( 'Lot Vacancy'[Id] ),
FILTER ( 'Lot Vacancy', 'Lot Vacancy'[IsRental] = TRUE () )
)
You can use REMOVEFILTERS or ALL and use your DATE column and related table to remove that slicer effect.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
2 Replies
You can use REMOVEFILTERS or ALL and use your DATE column and related table to remove that slicer effect.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/Hi,
As a side note, you do not need to use the FILTER() function.
