New article: Optimizing SWITCH on slicer selection with Group By Columns
This article describes how to use the Group By Columns property to store the slicer selection by using the same column used in a SWITCH function to optimize the query performance.
Read more


We released another update on SQLBI+ (more info on the blog post announcement):
Different types of many-to-many relationships

This 1-hour session explains the different meanings of "many-to-many" relationships: the cardinality type of a Power BI relationship does not correspond to the canonical meaning of many-to-many relationships between business entities in a data model.

More about SQLBI+


Marco will be in Australia in June 2023 for three Mastering DAX classroom courses!

Hurry and book your seat before the courses sell out!
Overall schedule
Mastering DAX Australia 2023


Latest news
• Navigating the Data Ecosystem: a revolutionary analytics architecture
You should never trust an article published on April 1st, because it is likely to be there for April Fools' Day. And this is written by none other than ChatGPT-4!
Apr 1, 2023 · ChatGPT-4
• Behind the scenes of an April Fools’ Day
Reading how we used ChatGPT-4 to write the April Fools' Day article is even more interesting. The first prompt is not always the right one.
Apr 2, 2023 · Marco Russo
• How to manage Reporting Objects in a Power BI dataset
Should a semantic model include report-specific objects? In Power BI there are no choices, you must mix them with the true semantic model objects. But we can try to keep them separate as much as possible following a few best practices.
Apr 4, 2023 · Kurt Buhler
• Identifying CPU and memory-intensive Power Query queries during refresh in the Power BI service
The Profiler provides information about CPU and memory consumed by Power Query transformations during a process refresh. These details are hidden in the textual description of the event. We are waiting for a better user experience in DAX Studio to read these events.
Apr 2, 2023 · Chris Webb


Latest videos
Optimizing fusion optimization for DAX measures
18:12#articleMarco Russo
Displaying only child values in parent-child - Unplugged #46
12:15#unpluggedAlberto Ferrari
Welcome to SQLBI+
06:54#announcementMarco Russo