SUMMARIZECOLUMNS best practices and Sideways recursion in DAX calculation groups
Don't miss the next newsletter - Subscribe now!
NEW ARTICLE
SUMMARIZECOLUMNS can now be used in measures, but you must follow the best practices to avoid incorrect results!
Read more

 

NEW ARTICLE
This article describes the sideways recursion triggered by invoking a calculation item from another calculation item, explaining why it should be avoided to steer clear of unexpected results.
Read more
 
COMICS
AI BI Blunders
This comic has been generated by ChatGPT using the AI Comic Maker GPT and so many prompts...

Please, give us your feedback!

:) Smile
:| Meh

 
CLASSROOM COURSES
Mastering DAX in London
Marco will be in London in October 2025!
Reserve your seat now: This is the only course in the UK for 2025!
Overall schedule
Mastering DAX in London, UK - October 2025
 

BI-WEEKLY NEWS DIGEST
Latest news
• Creating and editing Direct Lake semantic models
There are two flavors of Direct Lake: on SQL and on OneLake. We like the latter, but not all the tools are ready, so we need to adapt. Enjoy the ride.
Jul 26, 2025 · Zoe Douglas
• Running a Power BI Performance load test using Visual Studio Code
Now that in one way or another, you - or hopefully, your employer - have to pay for storage and compute, it's time to get familiar with optimization. That's one way you keep your money in the bank. It is never too late to start worrying about measuring the cost of your models and reports.
Jul 30, 2025 · Gilbert Quevauvilliers
• On-premises data gateway July 2025 release
Progress should be measured by the effort required to update the data gateway every month. Anyone delegating this task to an AI agent? That would be a tangible sign of innovation.
Jul 30, 2025 · Microsoft
• Why do Power BI Copilot AI instructions seem to work better in Desktop than in the service?
Spoiler alert: it's latency. Eventually, computers will remove waiting lines. At the moment, we have to wait for them.
Aug 3, 2025 · Chris Webb



SQLBI YOUTUBE CHANNEL
Latest videos
AI in Power BI: Time to pay attention
39:08#articleKurt Buhler
Why we waited so long to talk about AI
06:25#editorialMarco Russo
ALLSELECTED best practices
21:43#articleAlberto Ferrari
Choosing between DISTINCT and VALUES in DAX
18:09#articleMarco Russo
Synoptic Panel v2 Launch
02:00#announcementMarco Russo