Forum Discussion

giuliapiazza94's avatar
giuliapiazza94
Icon for Helper IV rankHelper 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
Icon for Community Champion rankCommunity Champion
4 years ago

giuliapiazza94  does ALLEXCEPT helps your scenario

 

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

 

giuliapiazza94's avatar
giuliapiazza94
Icon for Helper IV rankHelper 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