Forum Discussion
TOPN for two columns
You can follow the steps below to get the Top5 values.
1. Create a measure to sum Total Charges
SumTotal = SUM(Data[TotalCharges])
2. Create a measure to get the Rank number
Rank = RANKX(ALL(Data[Customers]),[SumTotal],,DESC)
3. Create a Matrix using Monthly Charges, Customer, SumTotal and Rank than use filter feature to only show Top5
Hi Zubair,
I tried this but ranking is not working for me.
Rank = RANKX(Data, Data[TotalCharges],1,ASC,Dense)
pbix file : https://1drv.ms/u/s!AhVscPhmToJ0k7gby4TGxHoEdq9z8Q
You can follow the steps below to get the Top5 values.
1. Create a measure to sum Total Charges
SumTotal = SUM(Data[TotalCharges])
2. Create a measure to get the Rank number
Rank = RANKX(ALL(Data[Customers]),[SumTotal],,DESC)
3. Create a Matrix using Monthly Charges, Customer, SumTotal and Rank than use filter feature to only show Top5
Hi Anonymous,
Incredibale! Thanks a lot :smileyhappy:
But i have no idea how it works. :smileytongue: Is it fairly difficult level task?
Are there any tutorials available to practice DAX functions?