Forum Discussion
Anonymous
2 years agoNot applicable
Rankx with ALLSELECT +ALLEXCEPT
Hi Everyone, I am trying to differentiated the below two dax snippets based on the outer filter context. DAX 01 RANKX ( ALLSELECTED ( CUSTOMERS[CUSTOMER_PARENT_ID] ), CALCULATE ( [Total AR Amo...
Dangar332
Resident Rockstar
2 years agohi, Anonymous
RANKX (
ALLSELECTED ( CUSTOMERS[CUSTOMER_PARENT_ID] ),
CALCULATE (
[Total AR Amount],
ALLEXCEPT ( CUSTOMERS, CUSTOMERS[CUSTOMER_PARENT_ID] )
),
,
DESC,
DENSE
)
here you use allexcept as calculatemodifier so it remove only filter context not ignoring outer filter value
for ignoring outer filter value you will have to use it in table function not in calculate modifier.