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
MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

Hi RMDNA,

 

This depends on the context of your measures, can you please provide some sample data and the filters you want to apply.

 

Regards,

MFelix

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.