Forum Discussion
How to do RankX on multiple columns ?
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 )
Georgia_H what is the result you want to get?
Can you share a sample copy paste table and hard code the result and the logic for it.
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 Georgia_H in your sample data, why is this the result of the rank?
80 1st place
0 2nd place
3 3rd place
?
You can also PM me and we could do a quick zoom if you wantHI SpartaBI
Sorry for the typo in the sample output.
I have corrected it. Can you take below data for your testing? Appreciate it.
Period Region BU Metric_ID Domain Value Rank 28-Apr ASIA EISG PCM03 Config Mgt 0 3 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 2 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
