By default, a column filter in CALCULATE overwrites the existing filter over the same column.
How to learn DAX: https://www.sqlbi.com/guides/dax/?aff=yt
The definitive guide to DAX: https://www.sqlbi.com/books/the-defin...
CALCULATE function: https://dax.guide/calculate/?aff=yt