Forum Discussion
Recoil
3 years agoRegular Visitor
Rank Value Errors
Hello,
I have a simple table on a canvas. It is reading from my table 'Data' and Contains one column for customer # and another column for "Absolute DnU Value" which is formatted as Currency.
In the table, I am trying to rank the customers with the highest "Absolute DnU Value" so I added a new measure with the formula below but it is giving me all 1's in the rank column. Please help me to understand what I am doing wrong.
Rank = Rankx(All('Data'),Sum(Data[Absolute DnU Value]))
I even tried
Rank = Rankx(ALLSELECTED('Data'),Sum(Data[Absolute DnU Value]))
you can try this
Measure = RANKX(all('Table'[customer]),CALCULATE(sum('Table'[Absolute value])))pls see the attachment below