Hidden Sort By Columns in DAX Filter Context

You’ve built a simple “Sum for All Categories” measure that is so darn simple that it’s impossible for it not to work; but alas it does not. If the category column you were trying to remove from the filter context had a Sort By column assigned to it, that Sort By column might be sneaking into the filter context in the dark shadows of the night and keeping your measure from working. Here we’ll show you what’s broken as well as how to fix it.

Brian Grant

Brian Grant

Brian Grant is a masterful Senior Analytics Consultant by day, and a Power BI legend by night. A passion for Power BI drove him to holistically master the tool from all three perspectives: M, DAX, and the visualization layer. Brian is a constant teacher who leads Power BI training sessions, while sharing his wealth of expertise through video and blogging resources.
SHARE THIS
Share on twitter
Share on facebook
Share on linkedin
Share on email
RELATED POSTS

Subscribe

Subscribe to CSG. We’ll supply your inbox with the latest blog posts, training videos, and upcoming events.

Ready to wrangle your data?