Forum Discussion
Incorrect Rank on %
Hi all, I have a Field [METRICS] which calculates a percentage from another field [CONT] (Contains Sales, MArgin, Budget by POS Name) which is joined to field [CSD] that contains POS Names (Eg. ...
Hi villa1980 ,
Try below expression:
Measure = var _t = ADDCOLUMNS('CSD',"RANK",RANKX(FILTER(ALL('CSD'),[POS NAME]=EARLIER([POS NAME])),[MtTrgt_%],,DESC,Dense))
RETURN MAXX(_t,[Rank])
Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Thank-you for your reply, that has worked very well thank-you.
This should be an easy one, I have managed to produce a rank calculation based on a hirarchy which is below. However it is ranking blanks, I know I need Not (ISBLANK(....but am unsure where I put this within this calculation.
Any Help would be appreciated.
Rank by NPS =
VAR IsRMFiltered = ISFILTERED('CSD Master'[Regional Manager])
VAR IsAOMFiltered = ISFILTERED('CSD Master'[New AOM 1 May 2024])
VAR IsPOSFiltered = ISFILTERED('CSD Master'[POS Name])
RETURN
IF (NOT IsRMFiltered && NOT IsAOMFiltered && IsPOSFiltered,
RANK(DENSE,ALL('CSD Master'[POS Name]), ORDERBY(CALCULATE(SUM(NPS[NPS Score])),desc)),
IF (NOT IsRMFiltered && IsAOMFiltered && IsPOSFiltered,
RANK(DENSE,ALL('CSD Master'[New AOM 1 May 2024]), ORDERBY(CALCULATE(SUM(NPS[NPS Score])),desc)),
IF (IsRMFiltered && Not IsAOMFiltered && IsPOSFiltered,
RANK(DENSE,ALL('CSD Master'[Regional Manager]), ORDERBY(CALCULATE(SUM(NPS[NPS Score])),desc)),
BLANK()
)))