Forum Discussion
TOPN for two columns
I have three columns in subscriber dataset. - Customer ID, Monthly Charges and total Charges. I grouped Monthly charges column as below 0 to 20 21 to 40 41 to 60 61 to 80 81 to 10...
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
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?