Forum Discussion

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 ...

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")

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

Not applicable

2 years ago

Unless specified otherwise with PARTITIONBY or ORDERBY, yes!

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?
- 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)?
  - jeroenterheerdt
    Microsoft Employee
    2 years ago
    there is not yet, we are actively thinking through what this should look like. Please feel free to give your input on this form: https://forms.office.com/Pages/ResponsePage.aspx?id=v4j5cvGGr0GRqy180BHbR-XFZhNDe99FoNSD_SJIDNlUNkNRNEpUNEw1MlVKOTBEUlEwVTlUSlFOOS4u

Related content