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