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.   ...
  • ryan_mayu's avatar
    3 years ago

    Recoil 

    you can try this

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

    pls see the attachment below