Ranking wrong total

[Anonymous]

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 could not figure out the total sales of these selected customers. Total sales row returns the real total sales rather than only 6 customers in this example. I have checked many cases mentioning wrong total dax formula but still having trouble. Could you please help me ?

Thanks

[Anonymous]

Hi Again ,

Is there anyone who can help you regarding this issue I am having ?

Thanks

[amitchandak]

@Anonymous , Ate you using TOPN or Rank ?

Power BI: rankx, topn, dynamic topn with numeric parameters
https://youtu.be/cN8AO3_vmlY?t=25620

Learn Power BI: Dynamic TOPN using TOPN/Window and Numeric parameter: https://youtu.be/vm2mdEioQPQ

[Anonymous]

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 ?

[Anonymous]

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