Forum Discussion
MrVillareal
7 years agoRegular Visitor
RANKX in Table Matrix
Hi please your help with RANKX function. I created this measure: Rank Segment Sales = IF(NOT(ISBLANK([Sum of Net Sales])), RANKX( ALL('Profit Centers'[Segment Name]), [Sum of ...
- 7 years ago
I found the solution:
https://www.sqlbi.com/blog/marco/2014/07/16/use-of-rankx-with-decimal-numbers-in-dax/
My workaround is to use ROUND function in my measure [Sum of Net Sales].
MrVillareal
7 years agoRegular Visitor
I found the solution:
https://www.sqlbi.com/blog/marco/2014/07/16/use-of-rankx-with-decimal-numbers-in-dax/
My workaround is to use ROUND function in my measure [Sum of Net Sales].