Hello,
I am having issues using the RANKX function in my PowerPivot data model. I am trying to rank two different metrics by region, territory: sales and growth from last year. The sales rank works perfectly, but the growth rank seems to skip a rank when growth turns from positive to negative. I am thinking maybe RANKX does like crossing zero when there isn't an actual zero value present. Has anyone seen this before and have any tips? Any help will be greatly appreciated. I also have a picture linked below. Thanks!
Here are my measures:
Sales1 = CALCULATE(SUMX('TableX','TableX'[Sales1]))
Sales2 = CALCULATE(SUMX('TableX','TableX'[Sales2]))
Growth = [Sales2] - [Sales1]
Sales Rank =IF(HASONEVALUE('TableX'[Terr]),RANKX(ALL('TableX'[Terr]),[Sales1],,,dense),BLANK())
Growth Rank = IF(HASONEVALUE('TableX'[Terr]),RANKX(ALL('TableX'[Terr]),[Growth],,,dense),BLANK())
Image Example
https://ibb.co/fch4Jo
I am having issues using the RANKX function in my PowerPivot data model. I am trying to rank two different metrics by region, territory: sales and growth from last year. The sales rank works perfectly, but the growth rank seems to skip a rank when growth turns from positive to negative. I am thinking maybe RANKX does like crossing zero when there isn't an actual zero value present. Has anyone seen this before and have any tips? Any help will be greatly appreciated. I also have a picture linked below. Thanks!
Here are my measures:
Sales1 = CALCULATE(SUMX('TableX','TableX'[Sales1]))
Sales2 = CALCULATE(SUMX('TableX','TableX'[Sales2]))
Growth = [Sales2] - [Sales1]
Sales Rank =IF(HASONEVALUE('TableX'[Terr]),RANKX(ALL('TableX'[Terr]),[Sales1],,,dense),BLANK())
Growth Rank = IF(HASONEVALUE('TableX'[Terr]),RANKX(ALL('TableX'[Terr]),[Growth],,,dense),BLANK())
Image Example
