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")
AnneKeli's avatar
AnneKeli
Regular Visitor
1 year ago

FINALLY!! THANK YOU!!! I have been searching for HOURS for this solution. I cannot believe it's this complex to change the sort order. THANK YOU, THANK YOU, THANK YOU

jeroenterheerdt's avatar
jeroenterheerdt
Microsoft Employee
1 year ago

We want to change this and are working through options here. What would you like to have seen?

  • Lajouac's avatar
    Lajouac
    Advocate I
    1 year ago

    Hi jeroenterheerdt !
    I am very happy to have found this solution !
    I would have imagined an ORDERBY parameter inside the running sum function, in able to choose the column to use to order the running sum.
    Thanks for working on this !

    • jeroenterheerdt's avatar
      jeroenterheerdt
      Microsoft Employee
      1 year ago

      cool, because that's exactly what I was thinking 🙂

  • AnneKeli's avatar
    AnneKeli
    Regular Visitor
    1 year ago

    I acree with Lajouac - an ORDERBY parameter would be what I expected.