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
The ability to rank things is a very common requirement Finding the best customers computing the ranking position of products or detecting the countries with the best sales volumes are among the questions most frequently asked by management Ranking can… 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