Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Ranking wrong total

Dear All ,   I have already created dynamic ranking DAX formula that is dependable of filters I selected. As you see below , table is showing number of customers having higher sales properly but I ...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi amitchandak 

    I used rankx formula to sort customers from highest to lowest based on its sales. After that , I wanted to see total sales of only selected customers based on rankx formula.

     

    Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Again ,


    Formula that I am having trouble is below. Total sum is not changing depending on ranking option. I guess the issue is resulted from IF formula in the last row. Could you please navigate me on how to fix the problem ?