Hidden Sort By Columns in DAX Filter Context

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

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
Essential Power BI Reports For Senior Living Operators

Essential Power BI Reports for Senior Living Operators

Well-crafted Power BI reports can help senior living operators turn disparate data into coherent and actionable insights.

ur senior living operation and reap serious efficiency gains, we’ve assembled a list of Power BI reports that consistently deliver the most value. Read on to learn more!

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.