Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Rankx formula help

How do i edit this formula so that it doesnt return all the rows in my table?       RANKX(             CROSSJOIN(         ALLSELECTED(PRODUCT_DIM[SAP_MATERIAL]),         ALLSELECTED(PR...
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
3 years ago

Hi,

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

 

expected result measure: =
RANKX (
    SUMMARIZE (
        ALLSELECTED ( PRODUCT_FACT_table ),
        PRODUCT_DIM[SAP_MATERIAL],
        PRODUCT_ATTRIBUTES_DIM[SAP_MATERIAL_DESCRIPTION]
    ),
    [units prof]
)