List out top items with CONCATENATEX+ in DAX for Power BI

Top 5 customers, top 3 products listed with their values adjusting to filters is something I have always used a lot when creating Power BI DAX data models and there's a few steps to get there, so I discuss that here. This video shows how to combine CONCATENATEX, CALCULATE, TOPN, FORMAT, SUMMARIZE and more to get the desired output aggregating the values as needed.

To download example workbooks, enter email here: https://www.xlconsulting-asia.com/soc...

Some DAX formulas used:
Name & sales = CONCATENATEX('Main data','Main data'[Name]&" - "&'Main data'[Sales],", ",'Main data'[Sales],DESC)
Top 3 name and sales = CONCATENATEX(TOPN(3,'Main data'),'Main data'[Name]&" - "&'Main data'[Sales],", ",'Main data'[Sales],DESC)
Sales text = FORMAT([0. Total sales],"$0,.#k")
Top 3 name and sales , = CONCATENATEX(TOPN(3,'Main data'),'Main data'[Name]&" - "&FORMAT('Main data'[Sales],"$#,##0"),", ",'Main data'[Sales],DESC)
Top 3 unique brand and sales = CONCATENATEX(TOPN(3,SUMMARIZE('Main data',[Brand],"Sales",[0. Total sales]),[Sales],DESC),[Brand]&" - "&FORMAT([0. Total sales],"#,.0k"),", ",[Sales],DESC)

00:00 - Introduction
00:43 - Quick measures (no code)
01:37 - CONCATENATEX
03:24 - List names and their vaue
05:05 - Top N only
06:29 - SUMMARIZE then CONTACENATEX
10:41 - FORMAT