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...
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.
Here is an example of the data
| FE | Total Calls | Rank |
Adam | 24 | 3 |
| Brian | 30 | 2 |
| Chris | 80 | 1 |
| Drake | 12 | 4 |
| Eric | 5 | 5 |