Forum Discussion

sachintandon84's avatar
sachintandon84
Helper I
6 years ago
Solved

Can't break RANK TIES (cannot use RAND())

Hi,    I need to do a cumulative running total on a non-date measure, and have been able to do this, by creating a dynamic rank measure column (see below), and then another TOPN Measure that uses t...
  • Anonymous's avatar
    Anonymous
    6 years ago

    Here's how to rank correctly on a non-time dimension. Please adjust it to your needs. No randomness necessary.

     

    File attached.

     

    Best

    D

sachintandon84's avatar
sachintandon84
Helper I
6 years ago

Thanks. I'm on a Mac right now, and can't see the DAX in the pbix file.

Are you able to post the DAX.

 

Thanks in advance.

 

Sachin

Anonymous's avatar
Anonymous
Not applicable
6 years ago
I'm sorry, Sachin, I can't do it as there is more than one measure required and I don't have time to copy everything and explain how it works. It's all in the file.

Best
D
  • sachintandon84's avatar
    sachintandon84
    Helper I
    6 years ago

    ok thanks. I'll wait till I get access to my pc.

     

    Reza Rad's solution makes use of a date column, by dividing that by a large value and adding that to the column being ranked.

     

    Not a super neat or logical solution, so will wait till I can get access to read your DAX.

     

    thanks again,

     

    Sachin