Writing a DAX query using TOPN

Learn how to write a DAX query using TOPN to display the first elements in individual rows, grouping the remaining elements in a single “Other” row. The goal of the video is to show how to write a DAX query from scratch, reaching the final goal in small steps.
The query shown in this video can be useful to build tables in Excel (not PivoTables), report in Paginated Reports, and calculated tables in Power BI.

You can test the code using DAX Studio connected to the Power BI file available in this article, which has also a different approach based on measures that work in Power BI reports.

---