topic Re: Never filter a specific row when using a year filter in DAX Commands and Tips

Never filter a specific row when using a year filter

Anonymous — Tue, 30 Aug 2022 05:54:19 GMT

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 — Tue, 30 Aug 2022 06:21:41 GMT

Anonymous , A measure

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

Anonymous — Tue, 30 Aug 2022 06:45:25 GMT

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.