Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

 

Only single value is showing. I have written in TOM Model.
Not working!

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous ,

     

    From this screenshot, were [CaseType] and [M2] both measures? If so, it indeed returns only one single row because there is no row context in such a visual. You have to place some other fields like [CaseType] into visual.

     

    Regards,

    Yuliana Gu

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi v-yulgu-msft 

      I need only CaseType and Count in visualization(Column chart) based on date but here measure i can't show in legend.

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Microsoft Employee
        7 years ago

        Hi Anonymous ,

         

        I am confused about your scenario, would you please share the sample .pbix file for check?

         

        Regards,

        Yuliana Gu