Forum Discussion

BenediktW's avatar
BenediktW
Advocate I
2 years ago
Solved

Visual calculation: running sum - sorting issue

Hello together,   I ve tried to utilize the new visual calculations to calculate running sums (cumulative percentage sales per customers as running totals).   Anyhow, I have the problem that the ...
Need Help
  • BenediktW's avatar
    BenediktW
    2 years ago

    lbendlin 

     

    Finally I found a solution without runningsum but with visual calc, which is working properly:

    FORMAT(SUMX( WINDOW(1, ABS, 0 ,REL, ALLSELECTED([Customer, ],  [Sales]), ORDERBY([Sales], DESC
    )), [Share total Sales]) , "Percent")
BenediktW's avatar
BenediktW
Advocate I
2 years ago

That is the formular for running sum

 

My visual is sorted like this (based on Sales): 

However, as soon as I enter the visual calculation area, it automatically ignores the sorting of the table and just takes the alphabetical order of my category (Customer): 

 

  • jeroenterheerdt's avatar
    jeroenterheerdt
    Microsoft Employee
    2 years ago

    it's not a bug, it's how it was implemented right now. What do you expect? Do you want the visual matrix to _always_ be sorted on whatever is the visual?

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Unless specified otherwise with PARTITIONBY or ORDERBY, yes! 

      • jeroenterheerdt's avatar
        jeroenterheerdt
        Microsoft Employee
        2 years ago

        thanks for letting me know. What about the sort order from the model? And how about functions that don't have the ORDERBY and PARTITIONBY parameter, like RUNNINGSUM?

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago
      it's not a bug, it's how it was implemented

      that means the implementation was buggy 🙂

      • jeroenterheerdt's avatar
        jeroenterheerdt
        Microsoft Employee
        2 years ago

        no, that was intentional. It follows the model sort order, such a sorting columns. Just blindly following the sort order of the visual is not the only choice.