Forum Discussion
Solved
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
Deku
Super User
Super UserWrap the sum() in calculate() to for context transition to occur
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_Mathur
Hi,
Share the download link of the PBI file and show the expected result there.
- Deku
replace ALL with ALLSELECTED
Thanks....again! this worked! Although ranked in the right order, I am getting false ties:
