Forum Discussion

cjcj's avatar
cjcj
Helper I
3 years ago

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...
Need Help
cjcj's avatar
cjcj
Helper I
3 years ago

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.

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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
    )

    • cjcj's avatar
      cjcj
      Helper I
      3 years ago

      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? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.