Forum Discussion

HanhLe's avatar
HanhLe
Frequent Visitor
1 year ago

RANKING VALUE

Hi everyone, I want to make a ranking of product type for each lines follow these description, but I got wrong result, hope to receive your help, thanks  
TomasAndersson's avatar
TomasAndersson
Icon for Solution Sage rankSolution Sage
1 year ago

Hi, 
You need to remove filters on whatever A02, A03 is (products?) so that RANK evaluates over the entire product type and not just over each product. So something like:

 

Rank = 
RANKX(
    ALL(Products[Product]),
    [Average of PPH], //Or whatever measure you want to rank by
    ,
    DESC
    )

 

Try it out and if it doesn't work you can give some more info on how the data is structured and what measures you have been trying so I can give you more specific advice.

 

Good luck!