Forum Discussion
Top 5 SubClass in Top 5 Class by student count
I have a very simple Pivot Table in Excel that I am needing to recreate in Power BI but cannot seem to figure this out. It is the Top 5 SubClasses in the Top 5 Classes by student count. In excel ...
Each Class has dozens if not hundreds of subclasses. I need to report the top 5 Classes based on student count, and each classes corresponding top 5 subclasses. The only way I can think to do this is use RANKX to rank the Classes, Then use a visual for each of the top 5 ranks while using top N (5) subclasses. But this would be really messy.