Forum Discussion
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 ...
amitchandak
Super User
Super UserAnonymous , 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
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 ?