Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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...
johnt75's avatar
johnt75
Icon for Super User rankSuper User
1 year ago

What are the definitions of the other measures ?

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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
        )