Issue with Rankx in calculated column

[MostVIP2023]

Dear experts,

  When I use rankx in calculated column ,it returns 1 in all rows, would you pls advise me how to fix it?

[ryan_mayu]

what's the expected output?

is this what you want?

Column = RANKX('Table','Table'[金额],,DESC)

[MostVIP2023]

Hi @ryan_mayu ，

Thanks for your quick reply, I need to rank group by the first column,Product.

[ryan_mayu]

@MostVIP2023 

then you can create measure 

Measure = sum('Table'[金额])

Measure 2 = rankx(ALLSELECTED('Table'[产品]),[Measure],,DESC)

[MostVIP2023]

Hi  @ryan_mayu ,

I need to rank in calculated column.

[ryan_mayu]

@MostVIP2023 

then you can try this

Column =

var _sum=CALCULATE(sum('Table (2)'[金额]),ALLEXCEPT('Table (2)','Table (2)'[产品]))

var _tbl=SUMMARIZE('Table (2)','Table (2)'[产品],"total",sum('Table (2)'[金额]))

return COUNTROWS(FILTER(_tbl,[total]>=_sum))