Forum Discussion

aquanr18's avatar
aquanr18
Frequent Visitor
7 years ago
Solved

Creating a Rank for each Item By Custumer

Hi! tnx a lot for reading my post,  My goal is to obtain the row TOP in powerr bi using rankx,                          This is a rank for each item by customer in the same table....
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    aquanr18 Please try this as a "New Column"

     

    Top = RANKX(FILTER(Test58Rank,Test58Rank[Client]=EARLIER(Test58Rank[Client])),Test58Rank[Sales],Test58Rank[Sales],DESC)

aquanr18's avatar
aquanr18
Frequent Visitor
7 years ago

I have try both, in the measure i got the previus error, 

If I use a calculated the error is 'Function 'RANKX' dose not support comparing values of type text with values of type integer, consider using the value or format function to convert one of the values' 

LivioLanzo's avatar
LivioLanzo
Icon for Solution Sage rankSolution Sage
7 years ago

aquanr18

 

can you post the table on which you apply this formula via a calculated column

 

 

    • PattemManohar's avatar
      PattemManohar
      Icon for Community Champion rankCommunity Champion
      7 years ago

      aquanr18 Please try this as a "New Column"

       

      Top = RANKX(FILTER(Test58Rank,Test58Rank[Client]=EARLIER(Test58Rank[Client])),Test58Rank[Sales],Test58Rank[Sales],DESC)

      • aquanr18's avatar
        aquanr18
        Frequent Visitor
        7 years ago

        Thanks ! this is exactly what I wanted, may you explain how does the formula work?