Forum Discussion
Rank calculation based on dynamic dimension parameter
HI Team, Can anyone please help me with the below Rank calculation. Rank = RANKX(ALL(RESULTS[Country]),CALCULATE(SUM(RESULTS[CADRE POINTS]))) - Working Rank = RANKX(ALL(p.Dimension[p.Dimen...
This is my P. Dimension Breakdown looks like
P.Dimension Breakdown = {
("Name", NAMEOF('RESULTS'[Name]), 0),
("Region", NAMEOF('RESULTS'[Region]), 1),
("Country", NAMEOF('RESULTS'[Country]), 2),
("Agency Network", NAMEOF('RESULTS'[Agency Network]), 3),
("Holding Company", NAMEOF('RESULTS'[Holding Company]), 4)
}