We released a new course for our SQLBI+ subscribers: Security in Tabular Semantic Models. This course explains how to implement security in Tabular semantic models, considering different requirements, data model design, DAX implementation, and performance. The training is reference material… Read more
How to implement security in Tabular semantic models considering different requirements, data model design, DAX implementation, and performance. Read more
This article describes how to implement a dynamic Pareto calculation in Power BI based on a measure that can be selected from a slicer and dynamically filtered by other slicers in the report. Read more
When using time intelligence functions, the automatic REMOVEFILTERS on Date can make maintaining filters on the Date table challenging. This article shows a technique to handle filter-preserving columns in DAX. Read more
Hierarchies are often created in data models to simplify the browsing of the model by providing users with suggested paths of navigation through attributes The definition of the hierarchies follows the requirements of the model For example the Date table… More on DAX Patterns
Optimizing DAX is the state-of-the-art book on optimizing DAX expressions in Power BI and Analysis Services semantic models.
Learn how to locate performance bottlenecks, read the query plan and performance metrics, rewrite the slower part of an expression, and measure the performance improvements. Read more
Amsterdam, NL
Marco Russo
Marco Russo & Alberto Ferrari
May 28-30 - Chicago
Aug 19-21 - Toronto