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]>)

     

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])
    )

 

jxavier111's avatar
jxavier111
Frequent Visitor
2 years ago

best solution ever!!!
Thankyou.