Never filter a specific row when using a year filter

[Anonymous]

Hey, 

I have a problem that i assume is extremely easy to fix but i can't get my head around it. 

I have a Year column, 2021, 2022 or 2023, which i a want to filter on. 

I also have another text column, with two values "Filter" and "Don't Filter". 

(The "Don't Filter" rows do have a Year value assocaited with them at the moment but this can be blanked or Nulled if needed)

I want to be able to filter my table based on the Year column, but i never want to filter out the "Don't Filter" rows. 

How do i go about this?

[amitchandak]

@Anonymous , A measure

calculate(Sum(Table) , Filter(Table, Table[Column] <> "Don't Filter" ))

[Anonymous]

Hi, 

Not sure what the code above should do. Also, i tried it and it says i can't use SUM() over a full table, only a column.