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

Hi,

 

I tried updating it yesterday, but it kept saying I had the latest version (from 2017), and kept giving the 'object instance error' when I tried to open your pbix file.

 

The funny thing is I can upload the pbix file to power Bi online (through the get data option). I can even edit the report online. But online, it won't allow me to view the DAX. And when I try opening the file on desktop, I get that error saying the file can not be opened : (

 

 

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