Forum Discussion

Recoil's avatar
Recoil
Regular Visitor
3 years ago
Solved

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]))