Forum Discussion

TTS's avatar
TTS
Frequent Visitor
1 year ago
Solved

Sum cumulative measures

I have measure that calculates cumulative sales from fact_sales. Then I have another measure that calculates cumulative sum for backlog from fact_ob. Both tables are linked to dim_calendar.   Now I...
  • Cookistador's avatar
    1 year ago

    Hello, you should have something similar to this measure

     

    TotalCumulativeDemand =
    VAR CurrentDate = MAX(dim_calendar[Date]) // Get the current date from the axis
    VAR CumulativeSales =
    CALCULATE(
    SUM(fact_sales[SalesAmount]), // Replace with your actual sales column
    FILTER(
    ALL(dim_calendar[Date]),
    dim_calendar[Date] <= CurrentDate
    )
    )
    VAR CumulativeBacklog =
    CALCULATE(
    SUM(fact_ob[BacklogAmount]), // Replace with your actual backlog column
    FILTER(
    ALL(dim_calendar[Date]),
    dim_calendar[Date] <= CurrentDate
    )
    )
    RETURN
    CumulativeSales + CumulativeBacklog

     

    Or you can try to do it with New visual calculation

     

     

    If it is not what you are trying to achieve, let me know and maybe share an example with us

  • TTS's avatar
    TTS
    1 year ago

    Basically this solved the case. Just needed some tuning for some points for my case and data. Great thanks.