RANKING VALUE

Hi HanhLe , hello TomasAndersson, thank you for the prompt reply!

Check the following measure:

Top PPH = 
VAR CurrentProductType = SELECTEDVALUE('Table'[Product Type])  
VAR CurrentLine = SELECTEDVALUE('Table'[Line])               

RETURN
    RANKX(
        FILTER(
            ALL('Table'),                                   
            'Table'[Product Type] = CurrentProductType      
        ),
        CALCULATE(SUM('Table'[PPH])),                                       
        ,
        ASC,                                                  
        DENSE                                                
    )

 Result:

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.