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 ,

 

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