Forum Discussion

giuliapiazza94's avatar
giuliapiazza94
Helper IV
4 years ago
Solved

Exclude all filters except one

Hi guys,

I want to do a measure that is filtered by only one filter, so I want to exsclude all the others.

I have tried using ALL() but there are many, many, many tables so I'm looking for a function faster.

 

Thank you all 😁

Need Help

5 Replies

  • bcdobbs's avatar
    bcdobbs
    Community Champion
    4 years ago

    Best way is to remove all filters and then add back the specifc column you need.

     

    Like:

     

    Example = 
    CALCULATE(
        [Your Measure]
        REMOVEFILTERS(),
        VALUES('Product'[Brand])
    )

     

  • smpa01's avatar
    smpa01
    Community Champion
    4 years ago

    giuliapiazza94  does ALLEXCEPT helps your scenario

     

    ALLEXCEPT(<tbl>,<tbl[onlyColumnToKeepFilter]>)

     

    • giuliapiazza94's avatar
      giuliapiazza94
      Helper IV
      4 years ago

      I've tried but it doesn't work

       

      Altri ricavi TOT = CALCULATE([Altri ricavi], ALLEXCEPT(Calendario, 'Calendario'[Anno]))

       

       

      The total should be 293795,54, not 78,18