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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi

 

I've just downloaded the file and it opens without the slightest problem. Maybe you have to reinstall your PBI Desktop? All I can do is tell you the version of PBI Desktop I use and re-attach the file.

 

Release:
March 2020

Product Version:
2.79.5768.1082 (20.03) (x64)

 

Best

D

sachintandon84's avatar
sachintandon84
Helper I
6 years ago

Thanks!

 

My version was 2 months old. It now works.

 

This is a prety neat solution!

 

I see that you don't even use the RANKX function, but instead a nested double FILTER function - which I've not seen before. But it works.

 

The Cumulative Total function is also quite different, to what I had envisioned, but it works.

 

Thanks again for this!

 

Sachin