Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 showing 5 values as shown in the mention below image.
Rank Selection:
Solved! Go to Solution.
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.
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] ) )
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.
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
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] ) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |