Forum Discussion
Exclude visual-level filter on a measure
Hello,
I would like to know if there is a way to exclude a visual-level filter on a measure, while keeping page-level filters ?
Hi Anonymous ,
In this case you need filter functions like ALL() etc.
Please refer: https://docs.microsoft.com/en-us/dax/all-function-dax
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
v-yingjlCommunity Support
Hi Anonymous ,
In this case you need filter functions like ALL() etc.
Please refer: https://docs.microsoft.com/en-us/dax/all-function-dax
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Thank you v-yingjl ,
the "ALLEXCEPT" function was exactly what I was looking for.
- parry2k
Super User
Anonymous you have to write the measure to exclude that filter and then use that measure in your visual.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
parry2k Do you knox how could I do this ?
- parry2k
Anonymous The column filter you want to ignore just use that in the measure with ALL function and that will take care of it. but a lot more depends on how the model is setup.
something like this:
Measure Ignore Categorie = CALCULATE ( SUM ( Table[Amount] ), ALL ( Table[Category] ) )I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
- amitchandak
Anonymous , if they are the same(same column), I doubt you can. otherwise you can use all(Table[Column])
