Using the RANKX Function...return 1

[BSimmers]

Hi there - I am having trouble getting my RANKX function to work. I returns 1 for every row. See below, I am trying to do a rank by the ABSDayonDayPrice column. Any help would be welcome. Thanks, Ben.

[Deku · Accepted solution]

Wrap the sum() in calculate() to for context transition to occur

[Deku · Accepted solution]

Wrap the sum() in calculate() to for context transition to occur

[BSimmers]

That worked!! Thanks!

You might be able to assist with my next question...I need it Ranked by business date, it is currently ranking across all dates.

[Deku · Accepted solution]

replace ALL with ALLSELECTED

[BSimmers]

Thanks....again! this worked! Although ranked in the right order, I am getting false ties:

[Deku]

Try running on column(s) rather than table i.e. allselected(table[code]) so the sum is calculated on the required grain

[Ashish_Mathur]

Hi,

Share the download link of the PBI file and show the expected result there.