Forum Discussion

Icon for Helper I rank

Helper I

1 year ago

Solved

Issue with Rankx in calculated column

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
1 year ago
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))

Icon for Super User rank

Super User

1 year ago

then you can create measure

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

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

Icon for Helper I rank

Helper I

1 year ago

I need to rank in calculated column.

ryan_mayu
Super User
1 year ago
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))