DAX
-
Enhancing Your Golden Semantic Model with User Input Tables

Introduction While learning about Power BI, you are likely to learn that designing a star schema consisting of fact and dimension tables is critical to building a good semantic model. You will also learn that it is best practice to create “Golden” models that can be used to support multiple reports instead of creating a Continue reading
-
You Don’t Know Until You Test It: DAX Optimization

Introduction 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 as performant as possible. Sometimes you have a good idea about what pattern is best and other times you don’t. There are even times Continue reading
-
Underrated Power BI Feature: Measures as Visual Filters

Introduction 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 filters, which have to be applied on columns in a table, visual filters can be applied to either columns or measures. For example, Continue reading
