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.

Share This:
Twitter
Facebook
LinkedIn

Stay up to date with the latest customer data news, expert guidance, and resources.

More Resources

Your Data, Analytics & AI Partner

Industry leaders choose SkyPoint as their comprehensive and compliant Modern Data Stack Platform. A Certified Microsoft Solutions Partner, SkyPoint Cloud turns siloed data into connected experiences.