Forum Discussion

RafalK's avatar
RafalK
Advocate IV
10 years ago
Solved

Running Total on a non-date column

Hi guys, I am having some real problems with calculating a running-total in Power BI. Main problem here is that my running total should be based on a calculated measure.   Here is the problem: C...
Need Help
Tips and Tricks
Tutorial Requests
  • v-sihou-msft's avatar
    v-sihou-msft
    10 years ago

    RafalK

     

    Please try with following Calculated Measure for the cumulative sales. It should be able to reduce the calculation.

    Cumulative_Sales_Measure =
CALCULATE (
    SUM ( Table1[Sales] ),
    FILTER ( ALL(Table1), Table1[Sales] >= MAX ( Table1[Sales] ) ),
    VALUES ( Table1[Brand] )
)

    Regards,

     

RafalK's avatar
RafalK
Advocate IV
10 years ago

Thanks Simon,

This solution might work in theory, but the calculation eats all of my RAM (13 GB) and drops due to lack of space.

Perhaps Power BI just can't handle those calculations. I would probably have to push that to a Calculated Measure and this may be impossible.

 

Such a simple task, yet so hard to implement.

Thanks for the help.

metxtli's avatar
metxtli
Regular Visitor
8 years ago

 

Hi!

 

Did you found a solution to the memory problem? I have the same problem, we are trying to do the same exercise you put on the table.

 

Regards

JCarlos