Python - groupby function not working

[cyborgdroid]

I am trying to rank within a group in python. I know how to do this outside of python in powerBI, and also how to do it in python but the python script function yields errors. I tried using groupby + rank and also groupby + transform and both give errors. When inspecting the advanced editor, additional quotes were added to the function by powerBI, I removed them and it still didn't fix the error.

dataset['rank'] = dataset.groupby(""Category"")[""value""].rank(method=""dense"", ascending=False)

https://stackoverflow.com/questions/46998281/how-to-rank-within-a-group-in-python

[cyborgdroid]

Maybe there is some syntax issue that I am missing? If this isn't working in python then perhaps a lot of things won't work with python in PBI since this is a very basic pandas function that does not require importing any external libraries. PBI imports pandas by default and uses pandas dataframes as the default data structure.

[v-juanli-msft]

Hi @cyborgdroid

Since I am not the expert of Python, I can't figure out how to do the rank task with Python.

In Power BI, there is a simple way to do that.

Out of Edit queries, in the Report view, create measures

Measure = SUM(Table1[value])

Measure 2 = RANKX(ALLEXCEPT(Table1,Table1[category]),[Measure],,DESC)

Best regards

Maggie