Forum Discussion
Adding Ranks?
Hi All, I'm wondering if someone could help me with the following: I have two separate ranks I've done for 2 separate measures and I would like to be able to add up these ranking numbers to crea...
Hi Anonymous
Allways use a common dimention. Attached sample file with the proposed solution.
johnt75
Super User
Super UserWhat are the definitions of the other measures ?
Hi there, thank you so much for your response. So it's a bit tricky because these ranks are built with parameters. See below.
Industry Per Caps Rank =
VAR OverallRank =
RANKX(
ALLSELECTED ('Industry per Caps Rank'),
CALCULATE (SUM ('Industry per Caps Rank'[Industry Per Caps])),
,
DESC,Dense)
VAR SubCategoryRank =
RANKX (
ALLSELECTED ('Industry per Caps Rank'[Sub-Category]),
CALCULATE (sum('Industry per Caps Rank'[Industry Per Caps])),
,
DESC,
Dense
)
VAR ZoneRank =
RANKX (
ALLSELECTED ('Industry per Caps Rank'[Zone]),
CALCULATE (SUM ('Industry per Caps Rank'[Industry Per Caps])),
,
DESC,
Dense
)
VAR ChannelRank =
RANKX (
ALLSELECTED ('Industry per Caps Rank'[Channel]),
CALCULATE (SUM('Industry per Caps Rank'[Industry Per Caps])),
,
DESC,
Dense
)
VAR ManufacturerRank =
RANKX (
ALLSELECTED ('Industry per Caps Rank'[Manufacturer]),
CALCULATE(SUM ('Industry per Caps Rank'[Industry Per Caps])),
,
DESC,
DENSE
)
VAR CategoryRank =
RANKX (
ALLSELECTED ('Industry per Caps Rank'[Category]),
CALCULATE(SUM ('Industry per Caps Rank'[Industry Per Caps])),
,
DESC,
DENSE
)
RETURN
SWITCH (
TRUE (),
CONTAINSSTRING ( SELECTEDVALUE ('Selection Parameter'[Type]), "Channel" ) , ChannelRank,
CONTAINSSTRING ( SELECTEDVALUE ('Selection Parameter'[Type]), "Zone" ), ZoneRank,
CONTAINSSTRING (SELECTEDVALUE ( 'Selection Parameter'[Type]), "Sub"), SubCategoryRank,
CONTAINSSTRING (SELECTEDVALUE ( 'Selection Parameter'[Type]), "Category"), CategoryRank,
CONTAINSSTRING (SELECTEDVALUE ('Selection Parameter'[Type]), "Manufacturer"), ManufacturerRank,
OverallRank
)