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

Need Help

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

Advocate I

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
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
  Microsoft Employee
  1 year ago
  We want to change this and are working through options here. What would you like to have seen?
  - 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
Microsoft Employee
1 year ago
you can now do this with just runningsum (and without format): RUNNINGSUM([Sales], ORDERBY([Sales], DESC)). Then format the visual calculation using the data formatting option.
jeroenterheerdt
Microsoft Employee
1 year ago
Since July, you can do the same using just RUNNINGSUM with the OrderBy parameter

Forum Discussion

Visual calculation: running sum - sorting issue

Related content

Running Count in DAX Sorted by Date

Sorting

Calculate Run Rate

Running Maximum

Table Sort , sort order , comparer