ViewTube

Learn the differences between similar but different DAX functions that remove filters from the filter context. Article and download: ...

Defining the right contract is a key activity for a DAX developer using AI. Here we introduce the concept of a contract through ...

Learning DAX by examples is never a good idea! Watch why and get motivated in learning some theory first! Download sample ...

A DAX calculation can produce convincing values at the detail level and fail at the total. The problem is often that the business rule ...

How to use AI to identify relevant test cases in a semantic model and create repeatable DAX tests for a measure. Article and ...

How to leverage AI to refactor existing DAX code, remove duplicated parts, and centralize the common code in user-defined ...

How to define optional parameters in DAX user-defined functions and set default values for parameters not specified by the caller.

Why you should always filter columns and never filter tables with CALCULATE in DAX! Article and download: ...

Best practices for deciding when to use (and when not to use) KEEPFILTERS in CALCULATE filter arguments. Article and ...

Learn how to specify the parameter types in DAX user-defined functions using MEASUREREF, COLUMNREF, TABLEREF, and ...

How to apply a different formatting rule at each level of a hierarchy using ISINSCOPE in a measure or ISATLEVEL in a visual ...

A visual representation of the filter context in DAX can help understand the conceptual model. Article and download: ...

SUMMARIZECOLUMNS is a powerful and complex function in DAX that in 2025 can be used in measures. This article outlines the ...