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(ALLSE...
hi aj1973 , inscope did not yield any different resuts and unfortunately I cannot leverage video 2 for adding columns since I am on Direct Query.
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
)
thx for the suggestion amitchandak I tried Summarize(All..and the ranking is correct when I apply to Table 1(with all customers), but not correct under Table 2 with customer filter applied to just 1 customer. Wondering if the problem is occuring due to customer filter being a dim table?