Forum Discussion
RankX with filter
Hi I am running into a wall trying to figure out how to have Rankx to work with filters.
Rankx is currently working correctly on the full table (Table 1 below) using:
Rank = RANKX(
Summarize(ALLSELECTED('CustomerTbl'), 'CustomerTbl'[CustomerName]),
[Sales]
,,DESC
)
However, when I use the Customer filter I am getting strange rank results (see Table 2 below). I am using DQ so cannot provide dummy data, but any ideas, suggesions would be appreciated.
5 Replies
cjcj , if you do want rank to change then you can use all , try if that can help
Rank = RANKX(
Summarize(ALL('CustomerTbl'), 'CustomerTbl'[CustomerName]),
[Sales]
,,DESC
)
