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.
Hi cjcj ,
From the test in myside, I think you issue should be caused by [Sales] measure or your data model.
My Sample:
Result is as below.
In my sample I use sum to get sales value without any filter. Please check the calculation logic of your measure.
If this still couldn't help you solve your issue, please show me more details about your data model and your calculation logic.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.