This article shows an optimized DAX technique to display the first N products for each category in Power BI, adding a row that aggregates the value for all the other products. The companion video introduces the scenario and the general approach, while the article offers further insights and optimization solutions.
Read more


There was nothing normal about this year, and we acknowledge that. Hoping in a better 2021, here is what happened in the DAX world, and what to expect in 2021.
Read more


Latest videos

DAX Patterns


Latest news
• Dataset hub preview in Power BI services
You have a new menu item in the Power BI service, showing all the datasets regardless of the workspace. A better entry point to create new Excel and Power BI reports.
Dec 21, 2020 · Microsoft
• Using small multiples in Power BI to improve report performance
The small multiples feature released in Power BI December 2020 makes it possible to optimize reports that have multiple charts. The feature is not available for card visuals, but you can always use the free certified Card with States visual to do that.
Dec 20, 2020 · Chris Webb
• Power BI translations and the XMLA endpoint
You can translate table, measure, and column names in Power BI by using the XMLA endpoint. Now that Power BI Premium per User makes the feature available to a larger audience, you can follow this step-by-step guide to discover how to manage translations with Tabular Editor.
Dec 22, 2020 · Philipp Lenz
• Data modeling essentials & best practices
We will never get tired to say that a good data model is the first step to create fast reports and to reduce the DAX code required. This article is part of the "Doing Power BI the right way" series that describes many best practices for your Power BI reports.
Dec 31, 2020 · Paul Turley
DAX Formatter