Posts tagged #Intermediate DAX

Data Modeling vs DAX in Power BI: Solving Problems the Right Way (with Markus Ehrenmuller-Jensen)

LIVESTREAM DATE/TIME 📅

February 6th 2026 - 9:30AM (Pacific Time)

DESCRIPTION 📄

When should you solve a problem in the data model, and when should you solve it with DAX?

In this livestream, Markus Ehrenmuller-Jensen will walk through practical scenarios where you can take either route: modeling changes, DAX measures, or even report-level settings. Instead of “it depends,” you’ll see how to choose a clear, maintainable approach.

In this session, we discuss:

  • How a solid data model can simplify or eliminate complex DAX

  • When it actually makes sense to push logic into DAX instead of the model

  • Typical patterns: role-playing dimensions, cascading filters, synced slicers, and more - Trade-offs around performance, maintainability, and usability

  • How to think about long-term governance when mixing modeling and DAX solutions

Whether you’re a Power BI developer who loves writing measures or a data model purist, this session will help you decide where each piece of logic really belongs.

GUEST BIO 👤

​Markus Ehrenmuller-Jensen is the founder of Savory Data, with a career spanning project leadership, data engineering, and business intelligence architecture since 1994. He holds degrees in software engineering and business education and serves as a professor of databases and project engineering at HTL Leonding, a technical college. He is also certified in PL-300 (Power BI Data Analyst), DP-203 (Azure Data Engineer Associate Certification), DP-600 (Fabric Analytics Engineer Associate), and DP-700 (Fabric Data Engineer Associate).

Markus actively contributes to the global data community, speaking regularly at international conferences such as SQL Bits in London, Power BI Next Step in Copenhagen, Data Saturdays throughout Europe, and SQL Days. He co-founded SQL PASS Austria in 2013 and the Power Platform User Group Austria in 2016; both organizations merged in 2021 to form Data Community Austria. Since 2014, he has organized Data Community Austria Day in Vienna, fostering knowledge sharing among data professionals. In recognition of his technical leadership and community involvement, Markus has been honored as a Microsoft Data Platform Most Valuable Professional (MVP) since 2017.​

In addition to his speaking engagements, Markus contributes articles to reputable journals and has authored the book "Data Modeling with Microsoft Power BI," published in June 2024.

RELATED CONTENT 🔗

Markus's Website
Markus on LinkedIn
Markus on Bluesky
Data Modeling with Power BI (O’Reilly)
Selection2List DAX Package
Markus's GitHub

Dynamic Matrix Columns in Power BI: Show/Hide Based on Row Hierarchy

Video by: Reid Havens

Ever wish your Power BI matrix could respond intelligently to what’s visible in the row hierarchy? In this video, I’ll show you how to create a dynamic matrix where column values, like department, title, or other employee attributes appear or disappear based on what’s selected in your row-level hierarchy.

We’ll combine a few clever modeling tricks to keep your matrix clean, relevant, and user-driven. Tune in to learn more!

RELATED CONTENT 🔗

Field Parameters in Power BI

Posted on July 29, 2025 and filed under Visualizations.

Invisible (and Built-In) Categorical Sorting Trick for Columns in Power BI

Video by: Reid Havens

Ever wanted your matrix or table in Power BI to sort by a hidden value — without showing that value in the visual? In this video, I’ll show you a powerful trick using zero-width Unicode characters to embed an invisible sort order directly into your categorical columns.

We’ll walk through a demo using a dataset of transaction IDs and regions, and show how you can control sort behavior without cluttering your visuals. Tune in to learn more!

RELATED CONTENT 🔗

Built-In Sort for Columns

Posted on June 3, 2025 and filed under DAX, Design & Presentation.

Fixed-Window Charting in Power BI: Auto-Adjusting Calendar Periods

Video by: Reid Havens

Learn how to create a chart that always displays the same number of calendar periods, driven by slicer period selection, and regardless of if there is existing data (yet) for a period. This leverages a [DAX] generated table, relationships, and some auto-magic features. Tune in to learn more!

RELATED CONTENT 🔗

Creating a MTD/QTD/YTD Time Intelligence Slicer

Posted on January 28, 2025 and filed under DAX, Data Modeling, Visualizations.