topic Rankx formula help in DAX Commands and Tips

Rankx formula help

Anonymous — Mon, 08 May 2023 15:04:16 GMT

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]

Re: Rankx formula help

tamerj1 — Mon, 08 May 2023 17:08:39 GMT

Hi Anonymous

please try

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

Re: Rankx formula help

Jihwan_Kim — Mon, 08 May 2023 17:10:09 GMT

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

Re: Rankx formula help

Ajendra — Mon, 08 May 2023 18:42:02 GMT

Hello,

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

Thanks!!