How to override all filters using DAX!

Published 19 days ago • 1 min read

How to see ALL your data, with DAX

Hey there Reader,

Sometimes, when you're building something in Power BI, you may have filtered a visual or a page in a certain way... but THEN need to show a SUM, or a COUNT, or a PERCENTAGE that uses ALL your data, with no filters.​
​
​Use DAX and the ALL function to unfilter data!​

You can totally SHARE this email with your friends / colleagues / neighbors / pets. Just click that forward button in your email program.

Were you forwarded this email?

​Click here to get How To goodness in your inbox.​

​
(Yes, you can totally forward this email to your friends, colleagues, neighbors... whoever!)

Not loving How To Use Power BI in your inbox anymore? Unsubscribe here.

(because you should only get these emails if you love them and find them useful!)

Check out our How-To Subject collections

​Charts​

All our posts (so far) about how to make, format, and hack Power BI charts.

​DAX​

All our posts (so far) about how to do just about anything in DAX.

​Hot (& Fresh) Tips!​

Get the tea on all the weird/hidden things that make Power BI more useful.

Connect with me on LinkedIn.

I post a few times a week... and I try and make it fun. :)

​

Take care everyone,
​
Joe.
​

Subscribe to Joe Travers