Forum Discussion
Advocate IIgnoring filter in the measure
Hi pavel_severov ,
change your formula to ALL():
As parry2k mentioned: Auto-exist may play a rule in your example.
Read the following articel from Matco Russo: https://www.sqlbi.com/articles/understanding-dax-auto-exist/
or watch the video of Albert Ferrari: Auto-exist on clusters or numbers - Unplugged 22 on YouTube:
https://www.youtube.com/watch?v=aRntX-HiiN8
With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)
Super Userpavel_severov it should be ALL(Dept) not ALL(Dept[Regions])
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to 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.⚡
Advocate Iparry2k, but I need to ignore only Depts[Region] filter. All other filters must remain.
This is very simplified test/example. In real report there are lot of other fields and filters.
I can't understand why in situation like this ALL(Depts[Region]) doesn't work properly.