Ranking wrong total

Question

Dear All ,&nbsp;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 ?&nbsp;Thanks&nbsp;&nbsp;

amitchandak · Answer

Anonymous , Ate you using TOPN or Rank ?
&nbsp;
Power BI: rankx, topn, dynamic topn with numeric parameters https://youtu.be/cN8AO3_vmlY?t=25620
&nbsp;
Learn Power BI: Dynamic TOPN using TOPN/Window and Numeric parameter: https://youtu.be/vm2mdEioQPQ

anonymous · Answer

Hi&nbsp;amitchandak&nbsp;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.&nbsp;Thanks

anonymous · Answer

Hi Again ,&nbsp;Is there anyone who can help you regarding this issue I am having ?Thanks

anonymous · Answer

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 ?&nbsp;

Forum Discussion

Ranking wrong total

4 Replies

Related content

Wrong Total

Wrong Total in Table

Duplicate ranking

Total and Rank

Wrong total