Forum Discussion
Rankx with if statement not working
I am trying to rank the people based on the total calls they are getting.
I first created a total calls measure and then a rank measure. Finally i am trying to create a calculated column to show if the people's rank is top 30 or not. However, after using the if statement, some of the outputs are not correct.
here are the codes:
FE Rank =RANKX(ALLSELECTED('FE Territory'), [FE Total Calls],,DESC,Dense)
Top30 =IF('FE Territory'[FE Rank] <=30,"Top 30","Under 30")
2 Replies
- Ritaf1983
Super User
Hi Anonymous
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
