Running Total on two sets of Data

Hi Anonymous

You can create two measures in the model to calculate the running totals for actual and budget values separately. Add both to Line y-axis on the visual. 

Running Total of Actual =
CALCULATE (
    SUM ( SampleTable[Value] ),
    ALLSELECTED ( SampleTable[Date] ),
    SampleTable[Date] <= MAX ( SampleTable[Date] ),
    SampleTable[Spreadsheet Field] = "Actual Units"
)

Running Total of Budget =
CALCULATE (
    SUM ( SampleTable[Value] ),
    ALLSELECTED ( SampleTable[Date] ),
    SampleTable[Date] <= MAX ( SampleTable[Date] ),
    SampleTable[Spreadsheet Field] = "Budgeted Units"
)

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Hi Anonymous 

Use this measure for actual units. 

Running Total of Actual = 
VAR lastActualDate =
    CALCULATE (
        MAX ( SampleTable[Date] ),
        ALLSELECTED ( SampleTable[Date] ),
        SampleTable[Spreadsheet Field] = "Actual Units"
    )
RETURN
    IF (
        MAX ( SampleTable[Date] ) <= lastActualDate,
        CALCULATE (
            SUM ( SampleTable[Value] ),
            ALLSELECTED ( SampleTable[Date] ),
            SampleTable[Date] <= MAX ( SampleTable[Date] ),
            SampleTable[Spreadsheet Field] = "Actual Units"
        ),
        BLANK ()
    )

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.