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

    ),
    [units prof]
    ,)

3 Replies

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Hi Anonymous 

    please try

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

  • 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]
)
  • Ajendra's avatar
    Ajendra
    Icon for Resolver I rankResolver I
    3 years ago

    Hello,

     

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

     

    Thanks!!