Forum Discussion
Arnault_
Resolver III
Resolver IIIRankx ignoring 1 column
Hi All, I have created a measure wich worked well until I decided to add one column in the table below (the last column). Now the Rankx measure interacts with the last columns. Could you help me fix...
the new column affects the ranking unexpectedly, consider explicitly excluding it from the calculation using REMOVEFILTERS or KEEPFILTERS to refine the ranking context.
RANKX (
REMOVEFILTERS ( XN_ART_DEPOT[LastColumn] ),
[Volumes moy. stockés],
,
DESC
)
This adjustment should help isolate the RANKX calculation from the impact of the newly added column. Let me know if further clarification is needed!