Forum Discussion
Solved
How to do RankX on multiple columns ?
Hi all, i am struggling with RANKX funtion on multiple columns. All the columns are from the same table.
I want to rank across different reporting Period, Region, BU, Metric_ID, Domain based on Value column in DESC order.
Could anyone help me with the syntax to achieve my requirement? Many thanks in advance.
Georgia_H this is for a measure:
Rank Measure = VAR _value_test = NOT ISBLANK (CALCULATE(SUM('rep F_ITS_MetricsLanding'[Compliance_Num]))) VAR _result = RANKX( ALLSELECTED('rep F_ITS_MetricsLanding'[LBU]), CALCULATE(SUM('rep F_ITS_MetricsLanding'[Compliance_Num])) ) RETURN IF( _value_test, _result )
8 Replies
Hi SpartaBI
Please refer to my desired result on column RANK.
My requirement is:
1.For April, I want to rank the best performing BU for Metric ID : PCM03, in ASIA & AFRICA regions in DESC mode
1.For April, I want to rank the best performing BU for Metric ID : PCM04, in ASIA & AFRICA regions in DESC mode and the same for May month.
Period Region BU Metric_ID Domain Value Rank 28-Apr ASIA EISG PCM03 Config Mgt 0 2 28-Apr ASIA EISG PCM04 Config Mgt 100 1 28-Apr ASIA PACS PCM03 Config Mgt 80 1 28-Apr ASIA PACS PCM04 Config Mgt 43.7255 2 28-Apr ASIA PAMB PCM03 Config Mgt 49.0197 3 28-Apr AFRICA PBGI PCM03 Config Mgt 62 2 28-Apr AFRICA PBLIT PCM03 Config Mgt 99 1 31-May ASIA PAMB PCM04 Config Mgt 97.1961 2 31-May ASIA EISG PCM03 Config Mgt 0 3 31-May ASIA EISG PCM04 Config Mgt 100 1 31-May ASIA PACS PCM03 Config Mgt 60 1 31-May ASIA PACS PCM04 Config Mgt 13.7255 4 31-May ASIA PAMB PCM03 Config Mgt 49.0197 2 31-May ASIA PVA PCM04 Config Mgt 89 3
