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

Thank you for the feedback, in my case: I cannot take simply any sorting order from the model as the sorting order must be based on a measure here. Thats why I currently see no way how to use the runningsum calculation for my advantage. 

When a "visual" calculation is ignoring the set-up of my visual, but is taking randomly alphabetical order of the category (my model is not sorted alphabetically) I dont really see the point.

This is also declared as a issue in various reviews (e.g. : DAX Fridays #225: RUNNINGSUM | Visual calculation functions - YouTube)   Minute 2:30)) 

 

In case I missed it: is there any option influence the runningsum sort-oder (besides query editor)?