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

Anonymous , Try using

Ensure that you have calculated the ranks for both measures correctly. You can use the RANKX function in Power BI to rank your measures.

Industry Per Caps Rank = RANKX(ALL('Table'), 'Table'[Industry Per Caps], , ASC, Dense)
Observed Drinker Rank = RANKX(ALL('Table'), 'Table'[Observed Drinker], , ASC, Dense)


Create the Combined Score: Once you have the ranks, you can create a new measure to sum these ranks.
Consumer Preference Score = [Industry Per Caps Rank] + [Observed Drinker Rank]


Visualize the Combined Score: Add the Consumer Preference Score measure to your visual to see the combined score for each zone.

  • 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
        )