Forum Discussion
RANKX 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 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!
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.
Hours. Tons of hours. That's what it took to finally find this post. And guess what - after three years, MSFT still hasn't fixed this comical issue. Had to set Sales $ column in "advanced editor" to be an integer like you said (Int64.Type), and magically my RankX calc that was ranking brands would finally give the right rank at all times when isolated to a single brand in a card. It's like the BI and Excel teams have never talked.
I noticed this behaviour for the first time this evening and I couldn't work out what the issues was and finally stumbled on this thread. In addition to JOKA's advice, I found that changing the data type of the underlying column to Currency (Cuurency.Type also solved the issue for me. I got that from Marco Russo's SQLBI Blog Use of RANKX with decimal numbers in DAX #powerpivot #ssas #tabular - SQLBI
