Forum Discussion
HappyG
8 years agoNew Member
RANKX Calculated Measure
Hi, I'm hoping someone can help! I have a table 'Performance' which has the below columns: Contract (number) SalesGroup (string) Month (date) Target (number) Actual (number) There...
Phil_Seamark
8 years agoMicrosoft Employee
Hi HappyG
Will the rankings change if you click various filters? Or do you want he rankings to be locked down each time you refresh data into the model?
HappyG
8 years agoNew Member
Hi Phil_Seamark,
Ideally would like to update with selected parameters, but both dynamic and static measures would be useful to get an ‘overall’ and ‘within selexted’ Ranking.
Cheers.
Ideally would like to update with selected parameters, but both dynamic and static measures would be useful to get an ‘overall’ and ‘within selexted’ Ranking.
Cheers.