RankX and filter/ row context

[brianhadley]

I am wanting to use RankX to rank people by sales performance in two ways: 1. performance against others on their supervisor 'team', and 2. performance against the entire group, regardless of supervsor team.

Currently I have the following measure defined, which I thought would accomplish #2 when I sliced or filtered by supervisor, but instead behaves as described in #1:

=rankx(all(sales[Agent]),[Sum of HIS Sales])


(HIS in 'HIS Sales' is just an acronym). What argument to table parameter in rankx will get the formula to evaluate for all agents in the dataset, regardless of filter context.

 

[Jacob Barnett]

Brian,

To get the RANKX to work for everything regardless of filter context you should use:

=RANKX(ALL(Sales),[Sum of HIS Sales])

Its pretty important to understand why your original formula acted like it did - where you have a natural hierarchy like Employee>Team when you open out the filter context on employee, the team filter context remains.
<team, when="" you="" open="" out="" the="" filter="" context="" for="" employee,="" team="" remains.

Depending on your final goal, you might also find the way ALLSELECTED() behaves interesting.</team,>