Rank function not working

Hello So i have created a calculated field called FCPU and now I would like to rank each building by generation of the building using the FCPU. So the lower the FCPU the higher the rank of the Building should be. I ran into issues with the formula.
The formula does not work in the following state(nothing gets calculated and breaks the visual):
The formula does work in this state how ever does not give the desired results.
rank([FCPU DESC], [FC,Gen], PRE_AGG)

Hi @nellsarg,

I think there may be an issue with your partition. If your screenshot is representative of your entire dataset, it looks like there is only one row for every combination of FC and Gen. That’s why everything has a rank of 1.