Forum Discussion
Advocate IRANKX in Card
In case there´s someone else with the same problem. There´s something wrong when you try to rank decimals. To solve the problem we had to change the measure in the overall rank to integer.
Hi JOKA ,
You can create the following two measures to display rank:
Normal Rank =
Overall Rank = RANKX(ALL(TABLE[User]),CALCULATE(SUM([Sales]),,DESC,Dense)
Then try putting the Normal Rank in a table visual and then Overall Rank Measure in the Card Visualization. Now if you will slice and click on, let's say Rank 3 record in the table, the card will show Rank 3 as well.
Hope this helps.
**Please mark this as answer if it solves your problem. Thanks
JOKAThank you Anonymous. I tried this but it doesn´t work. I believe there´s something else. I tried the same solution that you gave me in another dataset and it works perfect, but in this one it doesn´t. The only difference that I can see is that there are negative values in the Sales mesasure in this one, could that be the problem?
I don't think it is because of the negative sales figures. To test this quickly is to wrap the ABS function on Sales and see if this works as expected. If not, any chance you could attached the PBIX file in here with removing the sensitive bits. I believe it may be because of the filters/slicers that are passing through which can be viewed by clicking on Edit Interactions and hovering on the card visual.
Thanks
Ashish
- JOKA
Hi Anonymous ! I still can´t solve this problem. I tried your recommendation in another dataset and it works perfect. But in this one it doesn´t.
I am sharing the link to the .pbix file: https://drive.google.com/file/d/155T88JrH1mciasgj3Dcx_7ZHwZwxV842/view?usp=sharing
Hope you could help me. I would be very grateful!
sivasraoHelper III
Yes, it is working. Great.
Thank you.