Forum Discussion

bptyates's avatar
bptyates
Frequent Visitor
4 years ago
Solved

Ranking values

Hi All,    I have a list of sales orders and invoice values. I put them in a table to get a summary by part number:   When I try to use RANKX to rank those values it only works if I have th...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi bptyates 

     

    You can create a measure with below DAX

    Rank =
RANKX (
    ALL ( 'Final Sales data'[Material number] ),
    CALCULATE ( SUM ( 'Final Sales data'[Invoiced Sales] ) ),
    ,
    DESC
)

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi bptyates 

 

You can create a measure with below DAX

Rank =
RANKX (
    ALL ( 'Final Sales data'[Material number] ),
    CALCULATE ( SUM ( 'Final Sales data'[Invoiced Sales] ) ),
    ,
    DESC
)

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.