MCP Server: DAX Performance Tuner
With all of the buzz around MCP servers, I wanted to see if one could be created that would help you optimize DAX. Introducing - DAX Performance Tuner!
DAX¶
DAXing with DAX Noob: Episode 3
On this episode of DAXing with DAX Noob, we walk through two DAX problems posted on the Power BI Reddit channel and LinkedIn that involve some set functions...
DAXing with DAX Noob: Episode 2
On this episode of DAXing with DAX Noob, we walk through two DAX problems posted on the Power BI Reddit channel that involve some tricky evaluation context.
DAXing with DAX Noob: Episode 1
On this first episode of DAXing with DAX Noob, I walk through solving a question on the Fabric Community forum about a broken YTD Forecast measure.
Fabric Toolbox: DAX Performance Testing
Part of the role of the Azure Data Insights & Analytics team is to test new features and provide feedback to our engineering and product teams. However,...
Optimizing Rolling Distinct Count Measures
In my new role in Azure Data, I have spent a lot of time optimizing the performance of semantic models and DAX measures. One of the types of calculations we...
Creating User-Driven Default Slicer Selections
Recently, in an internal Power BI help forum, someone asked if there was a way to force a slicer's default selection to be based on a particular user's sign in.
You Don't Know Until You Test It: DAX Optimization
When working with DAX, there are many ways to get the same result, but performance can vary greatly. If you are anything like me, you want your code to be...
Underrated Power BI Feature: Measures as Visual Filters
One of the features I love in Power BI that I don't think gets enough love is the ability to use measures as filters on a visual. Unlike page or report...
