Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Rank

The rank formula works when SAP Material is the only measure on the row (1st image).  When I add in Sap Material Description it returns all values in the table and adds a rank of "1" to it (2nd image...
Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 years ago

Hi,

I am not sure how your datamodel looks like, but please try something like below.

 

RANK =
RANKX (
    FILTER (
        ALLSELECTED ( PRODUCT_DIM[SAP_MATERIAL], PRODUCT_DIM[SAP_MATERIAL_DESCRIPTION] ),
        NOT ( ISBLANK ( [UNITS PROF] ) )
    ),
    [Avg Weekly Units],
    ,
    DESC,
    DENSE
)