Forum Discussion

nranito's avatar
nranito
Helper II
8 years ago
Solved

Cumulative sum by columns

I have a table REQ in which I want to count values each day and show in a graph the cumulative sum, I used measure   Acumulate = CALCULATE(count(Reqs[ID]),FILTER(ALLSELECTED(Reqs),Reqs[DAY]<=MAX(R...
Need Help
Tips and Tricks
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    Hi nranito,

     

     

    Do you want to get a output like below? Calculate the cumulative sum of Sales per day and group by Type.

     

    If it is, you could refer to this measure.

     

    Measure 2 =
CALCULATE (
    SUM ( Table1[Sales] ),
    FILTER (
        ALLEXCEPT ( 'Table1', Table1[Type] ),
        'Table1'[Day] <= MAX ( 'Table1'[Day] )
    )
)

    If not, please share your data sample which could reproduce your scenario and your desired output.

     

    Best Regards,

    Cherry

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi nranito,

 

 

Do you want to get a output like below? Calculate the cumulative sum of Sales per day and group by Type.

 

If it is, you could refer to this measure.

 

Measure 2 =
CALCULATE (
    SUM ( Table1[Sales] ),
    FILTER (
        ALLEXCEPT ( 'Table1', Table1[Type] ),
        'Table1'[Day] <= MAX ( 'Table1'[Day] )
    )
)

If not, please share your data sample which could reproduce your scenario and your desired output.

 

Best Regards,

Cherry

nranito's avatar
nranito
Helper II
8 years ago

It's just that, thank you!

 

Can you explain what "allexcept" does? I tried, as you pointed, using GROUP BY, with no success...

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    8 years ago

    Hi nranito,

     

    You could have a view of AllEXCEPT function which introduce how to use it in more details.

     

    Best Regards,

    Cherry