topic Re: Exclude all filters except one in DAX Commands and Tips

Exclude all filters except one

giuliapiazza94 — Thu, 09 Dec 2021 16:43:19 GMT

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 😁

smpa01 — Thu, 09 Dec 2021 16:59:49 GMT

giuliapiazza94 does ALLEXCEPT helps your scenario

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

giuliapiazza94 — Fri, 10 Dec 2021 08:01:38 GMT

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

mh2587 — Fri, 10 Dec 2021 13:00:21 GMT

try ALLSELECTED FUNCTION

bcdobbs — Fri, 10 Dec 2021 18:43:10 GMT

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 — Wed, 20 Dec 2023 17:39:30 GMT

best solution ever!!!
Thankyou.