Exclude all filters except one

[giuliapiazza94]

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 😁

[bcdobbs]

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]

best solution ever!!!
Thankyou. 

[mh2587]

try ALLSELECTED FUNCTION

[smpa01 · Accepted solution]

@giuliapiazza94  does ALLEXCEPT helps your scenario

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

[giuliapiazza94]

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