Forum Discussion

Hidde's avatar
Hidde
Icon for Helper I rankHelper I
8 years ago
Solved

Count price position in PowerBI

Hi, I am struggling with finding a solution for this:   I have a lot of prices per product, so the data looks like this:   Product - client - price - Price Position Product 1 - Client 1 - €2 - 1...
Need Help
  • v-xjiin-msft's avatar
    v-xjiin-msft
    8 years ago

    Hi Hidde,

     

    To achieve your requirement, you can try this calculated column:

     

    Price Ranking =
RANKX (
    FILTER ( 'Rank', 'Rank'[Product] = EARLIER ( 'Rank'[Product] ) ),
    'Rank'[Price],
    ,
    ASC
)

     

    Thanks,
    Xi Jin.

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
8 years ago

Hidde you can create a measure and then place your fields on a matrix or table

 

Price Ranking = RANKX (all ('table',CALCULATE(sum('table'[price])),,ASC)

 

obviousy your price amount needs to be a decimal or whole number

  • Hidde's avatar
    Hidde
    Icon for Helper I rankHelper I
    8 years ago

    Thanks! Needs a little modification though because this only works if you have one product (I have multiple);

     

     

    Client 1Product 12
    Client 2Product 18
    Client 3Product 14
    Client 1Product 21000
    Client 2Product 22
    Client 3Product 2200

     

    Tried this but I it does not have correct order:

     

    Price position = RANKX(all(Table1),calculate(sum(Table1[Price]),values(Table1[Product])))

     

    • vanessafvg's avatar
      vanessafvg
      Icon for Community Champion rankCommunity Champion
      8 years ago

      Hidde

       

      Price Ranking = RANKX (all ('Price Position'[Client],'Price Position'[Amount]),CALCULATE(sum('Price Position'[Amount])))

       

       

      • Hidde's avatar
        Hidde
        Icon for Helper I rankHelper I
        8 years ago

        Thanks, but with that the highest amount has the highest ranking (1). Highest amount (or price) should have lowest ranking (3).