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

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 keep getting the following error when trying to open the pbix file:

 

Object reference not set to an instance of an object

 

Are you able to post a Excel Power Pivot solution?

 

Sachin

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    Update your PBI Desktop to the latest version.

    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