Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Top 20 Ranking

Hi,   Can someone please help me out with this one, I have searched the community and tried a number of the solutions tht have been provided but I have unfortunatley I haven't had any luck.   I w...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    You may download my PBI file from here.  You will see the Top 3 Pincodes by ratio in descending order.  The Top 3 are obtained by a DAX measure.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

Hi,

Share some data and show the expected result.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Ashish_Mathur 

     

    The data I am dealing with looks like

     

    Money InMoney OutPostcode
    14000190003001
    13000110003002
    22000130003003
    17000160003004
    11900110003005
    15672900003006

     

    Expected Result 

    • New Ratio column ranked highest to smallest
    Money InMoney OutPostcodeRatio
    15672900030061.74
    220001300030031.69
    130001100030021.18
    119001100030051.08
    119001100030051.06
    156729000030060.73



    Thank you for your response

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      4 years ago

      Write this measure and drag it to the visual

      Measure = divide(sum(Data[Money In]),sum(Money out))

      Sort this measure in descending order.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Ashish_Mathur yeah thank I have that calc sorted but how do I go about sorting them dynamically and then get a list of the top 20 in dax?