Power BI DAX and SQL — Top N
…using COUNTROWS and RANK
Starting out with Power BI? Learning a bit of SQL ?
Power BI and SQL works well together and understanding a little bit of DAX will help you understand a little about SQL and vice versa.
Here are two different ways to do top 3 by group using DAX and SQL.