Forum Discussion

George1973's avatar
George1973
Icon for Helper V rankHelper V
5 years ago
Solved

Optimization of Product Ranking Measure

Dear Community, I have the measure calculating product sales ranking adding to them ABCDX priorities like given below: Rank for Sales on Products = VAR RunningTotal_Prod_Sales=CALCULATE([Total ...
  • George1973's avatar
    George1973
    5 years ago

    Hi,
    Thanks a lot for the provided solution. I think there is a little mistake here:

    Is the first viriable there should be "RunningTotal_Prod_Sales" instead of "RunnigTotal_Prodsales_Share"..

     

    If I'm mistaken sorry for that 🙂

    The formula speed has been optimized indeed by 3 times, but as for the results (outcome) I have to check it once again, there seems to be some deviations

George1973's avatar
George1973
Icon for Helper V rankHelper V
5 years ago

Hi,
Thanks a lot for the provided solution. I think there is a little mistake here:

Is the first viriable there should be "RunningTotal_Prod_Sales" instead of "RunnigTotal_Prodsales_Share"..

 

If I'm mistaken sorry for that 🙂

The formula speed has been optimized indeed by 3 times, but as for the results (outcome) I have to check it once again, there seems to be some deviations

George1973's avatar
George1973
Icon for Helper V rankHelper V
5 years ago

Hi Again,

 

Yes, the formula works great! As communicated by 3 times faster!

 

Thanks a lot for your support!