Advanced DAX | Top N using Filter, Rankx, Topn, WhatIF parameter in Power BI.
Four different ways to get the Top N
1. Using normal visual filter
2. Using TOPN DAX function
3. Using WhatIF Parameter and implementing parameter value in DAX TOPN function
4. Using Rankx DAX function
**********************************************************************
Other topics you might like
Calculated Column and Measures in Power BI • Calculated Column and Measure in MS Power BI
DAX - Related Table in Power BI • DAX Related Related Table MS Power BI
Advanced DAX • Advanced DAX
Fuzzy Match in Merge Join in Power BI • Fuzzy Match in Merge Join Power BI Power Q...
Row Level Security in Power BI • RLS Row Level Security Power BI
DAX Left and Find in Power BI • Power BI | DAX | LEFT | FIND
Feed back using WhatIf Parameter in Power BI • Feedback | Power BI | What If Parameter
Include and Exclude filters in Power BI • Include | Exclude Filters in Power BI
Stacked and Clustered Chart • Stacked and Cluster Chart | Power BI
Line Chart • Line Chart in Power BI
Waterfall Chart • Waterfall Chart in Power BI
Ribbon Chart • Ribbon Chart | Power BI
Scatter Chart • Scatter Chart | Power BI
DAX - Finding Lost and New Customers • Advanced DAX | Finding the Lost and New Cu...
Area Chart • Area Chart | Power BI
Combo Chart • Combo Chart | Power BI
DAX - Closing Balance • Advanced DAX - Closing Balance | Power BI
**********************************************************************
Kindly like and subscribe for daily updates