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

Hi! thanks ! but the formula has something wrong
I got the error "A single value form column 'Sales' in the table 'Sales' cannot be determined. This can happen when a measure formula refers to a column that contains many values without an aggregation such as min, max, count or sum to get a single result'

 

I tryed to agreggate the sales by SUM but got nothing out of the formula. 

What should I do? 

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

aquanr18

 

are you using the formula in a measure or calculated column ?

  • 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'