New article: Filtering calculation items in a slicer
When a slicer contains many items, developers can filter the most relevant items using another slicer. The scenario is easily solved with a many-to-many relationship if the source is a regular table. Still, it requires some DAX coding if the slicer contains calculation items.
Read more


We have two new Mastering DAX classes: Other cities/dates only in 2024, hurry up!!
Courses schedule

While you wait to access the new DAX Optimizer tool (if you are not in the waitlist, you can still apply to enter the beta), you can read how we started the DAX Optimizer journey!
Read more


Latest news
• Power BI July 2023 updates
No big features this month, but important fixes like those for On-Object interaction. Is it now usable? We will give it a try. It's summertime in the Northern hemisphere, a consolidation version is good news.
Jul 11, 2023 · Microsoft
• Evaluation order of DAX expressions in calculation groups
What happens when the calculation item expression references the format string expression? If you know the answer, you have probably already read the complete analysis of how it works. Better not to be in that situation, but just in case...
• Performance testing Power BI Direct Lake mode datasets in Fabric
At SQLBI we decided to wait before covering Fabric, as there are too many missing parts to control the semantic model. However, it is never too soon to take a look at who runs the first experiments, and testing the Direct Lake mode for a dataset is interesting.
Jul 9, 2023 · Chris Webb
• The tale of Tabular Editor
Read the full story of Tabular Editor, the mandatory free and open-source tool whose development started in 2016.
Jul 10, 2023 · Daniel Otykier
• Using Tabular Editor in Microsoft Fabric
If you think that Fabric will bring you a web browser-only experience, read this article. Productivity and advanced features are still (and will continue to be) a realm for dedicated tools.
Jul 13, 2023 · Kurt Buhler
• SQLBIts 2023 videos available!
SQLBits is the largest conference for Data Platform, and it is also the most loved one by speakers and attendees. Why? For example, because videos of all the sessions are free on YouTube! The videos of SQLBits 2023 held in March 2023 are now available.
Jun 14, 2023 · SQLBits

Latest videos
Reading active Power BI security roles in DAX
20:43#articleMarco Russo
The Making of Optimizing DAX Second Edition - Unplugged #53
24:29#unpluggedAlberto Ferrari & Marco Russo