Forum Discussion

mohammedkhan's avatar
mohammedkhan
Icon for Helper I rankHelper I
6 years ago
Solved

Rank Selection Branches and Sub Branches

  Dear All, I have made Three Meaures and Rank Table where I enter the rank column value as 3 5 10 to use the Slicer as a top 3 to Top 10 Based on the Slicer selection, but when i select 3 it is sh...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • jdbuchanan71's avatar
    jdbuchanan71
    6 years ago

    Hello mohammedkhan 

    You can skip the ranking and use TOPN with your ranking measure to get your TOPN games.  It would look something like this.

    Top N Game Income =
VAR _Ranks =
    SELECTEDVALUE ( Ranks[Rank] )
VAR _RankingContext =
    VALUES ( 'Game Income'[Games] )
RETURN
    CALCULATE (
        [Total Game Income],
        TOPN ( _Ranks, ALL ( 'Game Income'[Games] ), [Total Game Income] ),
        _RankingContext
    )

    Take a look at this video for more information on the example.

    https://www.youtube.com/watch?v=bbM7JSQqn2I

  • jdbuchanan71's avatar
    jdbuchanan71
    6 years ago

    The problem you are running into is your ALL ( 'Games Income' ) is bringing the whole table, not just all the games.  What you want is this.

    Game Rank = 
IF ( 
    NOT ISINSCOPE ( 'Game Income'[Games] ), BLANK(),
    RANKX ( ALL ( 'Game Income'[Games] ), [Total Game Income] )
)

    And if you want the rank only on the TopN games you can use this.

    TopN Game Rank = 
IF ( 
    ISBLANK ( [Top N Game Income] ) || NOT ISINSCOPE ( 'Game Income'[Games] ), BLANK(),
    RANKX ( ALL ( 'Game Income'[Games] ), [Top N Game Income] )
)
jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
6 years ago

Hello mohammedkhan 

You can skip the ranking and use TOPN with your ranking measure to get your TOPN games.  It would look something like this.

Top N Game Income =
VAR _Ranks =
    SELECTEDVALUE ( Ranks[Rank] )
VAR _RankingContext =
    VALUES ( 'Game Income'[Games] )
RETURN
    CALCULATE (
        [Total Game Income],
        TOPN ( _Ranks, ALL ( 'Game Income'[Games] ), [Total Game Income] ),
        _RankingContext
    )

Take a look at this video for more information on the example.

https://www.youtube.com/watch?v=bbM7JSQqn2I

mohammedkhan's avatar
mohammedkhan
Icon for Helper I rankHelper I
6 years ago

Hi jdbuchanan71 Could you please help on the Ranking as well, i would like to bring the Ranking accoridng to the Game Income but it is ranking absurd like 

firsst three games are 1 then 2

Game 1 Rank1

Game 2 Rank1

Game 3 Rank1

Game 4 Rank2

 

where is should be like 

 

Game 1 Rank 1 

Game 2 Rank 2 

Game 3 Rank 3

Game 4 Rank 4

You can also see that into that same image where the ranking for first three games is  1

 

Game Income Rank = RANKX(ALL('Game Income'), [Total Game Income], , DESC)
  • jdbuchanan71's avatar
    jdbuchanan71
    Icon for Super User rankSuper User
    6 years ago

    The problem you are running into is your ALL ( 'Games Income' ) is bringing the whole table, not just all the games.  What you want is this.

    Game Rank = 
IF ( 
    NOT ISINSCOPE ( 'Game Income'[Games] ), BLANK(),
    RANKX ( ALL ( 'Game Income'[Games] ), [Total Game Income] )
)

    And if you want the rank only on the TopN games you can use this.

    TopN Game Rank = 
IF ( 
    ISBLANK ( [Top N Game Income] ) || NOT ISINSCOPE ( 'Game Income'[Games] ), BLANK(),
    RANKX ( ALL ( 'Game Income'[Games] ), [Top N Game Income] )
)