Forum Discussion
BSimmers
1 year agoFrequent Visitor
Using the RANKX Function...return 1
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.
Wrap the sum() in calculate() to for context transition to occur
replace ALL with ALLSELECTED
6 Replies
- DekuSuper User
Wrap the sum() in calculate() to for context transition to occur
- BSimmersFrequent Visitor
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.
- Ashish_MathurSuper User
Hi,
Share the download link of the PBI file and show the expected result there.