Rank Value Errors

[Recoil]

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

[Recoil]

@ryan_mayu Thank you so much!

[ryan_mayu]

you are welcome

[ryan_mayu · Accepted solution]

@Recoil 

you can try this

Measure = RANKX(all('Table'[customer]),CALCULATE(sum('Table'[Absolute value])))

pls see the attachment below