Forum Discussion

RafalK's avatar
RafalK
Icon for Advocate IV rankAdvocate 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
Icon for Advocate IV rankAdvocate 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.

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
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,