Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Never filter a specific row when using a year filter

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?

 

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , A measure

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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.