Forum Discussion
Avoid duplicate rank
I need help? I have written DAX for TOP 5 Case and remaining should be in 'Other' category based on MAX COUNT casetype that is working but problem is in duplicate rank. I have written in TOM Model a...
Hi Anonymous ,
I tested your provided DAX formula with my sample data, it returned expected RANK value which skips duplicates. You just need an extra measure to class the casetype.
Category = IF([Rank measure]<=5,SELECTEDVALUE(FactCase[CaseType]),"Other")
Best regards,
Yuliana Gu
ExpectedOutput I cannot keep in legend(chart) which you have given that is calculated column. In chart I want to use this column in legent section and measure will be count. If you are not clear then I will send sample data file as well.