Forum Discussion

RMDNA's avatar
RMDNA
Icon for Solution Sage rankSolution Sage
8 years ago

Dynamic rankx() with filters

Hi all,   I've looked into other rankx() posts, but they seem too simple for what I need. Providing a PBIX would be difficult - this has a lot of tables and data, and I can't possible sanitize ever...
Need Help
RMDNA's avatar
RMDNA
Icon for Solution Sage rankSolution Sage
8 years ago

MFelix, Zubair_Muhammad,

 

PBIX download

 

I've attached a sample PBIX. The table names and relationships are the same, the data is fabricated. Hopefully the numbers are valid - if not, they can be edited in Query Editor.

 

I'm looking for a working rank and running total, both of which respond to the slicers at the top of the page.

 

Thanks for the help, guys. I know this is a lot of work, and you answer half the questions on the board.

MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

Hi RMDNA,

 

I was looking at your data and got some questions what is the value over wich you want to rank the information (Total Sales - Product table or Sales Quantity - Customer sales) and what do you want to rank the customers or the products?

 

Regards,

MFelix

  • RMDNA's avatar
    RMDNA
    Icon for Solution Sage rankSolution Sage
    8 years ago

    MFelix,

     

    I'm looking to rank products by sales quantity.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      8 years ago

      Hi,

       

      I'd like to help.  Please share (in a Table) the exact numbers that you are expecting.