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 functi...
Need Help
  • smpa01's avatar
    smpa01
    4 years ago

    giuliapiazza94  does ALLEXCEPT helps your scenario

     

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

     

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