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")
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Is there a way to have the visual calculation respond to the sort order for any column of the table? 

 

Say I have a percent and cumulative percent, and I want that running tally to add up based on when I sort by column A or column B. Like it will dynamically respond to different sorting.

  • jeroenterheerdt's avatar
    jeroenterheerdt
    Microsoft Employee
    1 year ago

    no, right now, just like with a window function you dicate the exact sort order. We have not gotten around to making this responsive to however the visual is sorted.