Rankx formula help

[Anonymous]

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(PRODUCT_ATTRIBUTES_DIM[SAP_MATERIAL_DESCRIPTION])

    ),

    [units prof]

    ,)

[Ajendra]

Hello,

Please elaborate some more and if possible share some demo data alongwith the desired output.

Thanks!!

[Jihwan_Kim]

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]
)

[tamerj1]

Hi @Anonymous 

please try

=
RANKX (
SUMMARIZE (
CALCULATETABLE ( FactTable, ALLSELECTED () ),
PRODUCT_DIM[SAP_MATERIAL],
PRODUCT_ATTRIBUTES_DIM[SAP_MATERIAL_DESCRIPTION]
),
[units prof]
)