Forum Discussion
RankX excluding some values
Hi Anonymous ,
Then try this measure.
Rank Without GRp 1 = IF( SELECTEDVALUE('Table'[Unit]) = "Group1", BLANK(), RANKX (FILTER(ALL('Table'),'Table'[Unit] <> "Group1"), CALCULATE(AVERAGE('Table'[Average of Star Rating]))))Regards,
Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Hi Harsh. Thanks it works..
If you could also help me with Month on Month Rank change DAx.. My rank is changing month on month basis for same group.
I want to check the Rank difference of this month to last month (Trend)
Last Month Ranking
| Month | Unit | Divison Ranking check | Average of Star Rating |
| Feb | Group12 | 1 | 3 |
| Feb | Group11 | 2 | 2.76 |
| Feb | Group10 | 3 | 2.62 |
| Feb | Group9 | 4 | 2.57 |
| Feb | Group8 | 5 | 2.36 |
| Feb | Group7 | 6 | 2.33 |
| Feb | 7 | 2.29 | |
| Feb | Group5 | 8 | 2.22 |
| Feb | Group4 | 9 | 2.11 |
| Feb | 10 | 2.06 | |
| Feb | Group1 | 11 | 2 |
| Feb | Group2 | 11 | 1.95 |
| Feb | Group3 | 12 | 1.8 |
| Feb | TBA | 13 |
This month ranking
| Month | Unit | Divison Ranking check | Trend |
| Mar | Group12 | 13 | 12 |
| Mar | Group11 | 7 | 5 |
| Mar | Group10 | 4 | 1 |
| Mar | Group9 | 3 | -1 |
| Mar | Group8 | 3 | -2 |
| Mar | Group7 | 3 | -3 |
| Mar | 4 | -3 | |
| Mar | Group5 | 10 | 2 |
| Mar | Group4 | 2 | -7 |
| Mar | 9 | -1 | |
| Mar | Group1 | 9 | -2 |
| Mar | Group2 | 8 | -3 |
| Mar | Group3 | 9 | -3 |
| Mar | TBA | 4 | -9 |
Tend is representing this month to last month rank difference.. I am new in powerbi so not able to apply the Time intellegence function.. I believe you can answer this question too..
Regards
Uphar
Hi Anonymous ,
Can you create a separate post for this as too many questions in one post will confuse future users of the community.
In the other post, pls share proper data in text format, your calendar table structure and your data models to help you on this.
Appreciate your support on this.
Thanks
HN