Forum Discussion

dax_bee's avatar
dax_bee
Frequent Visitor
9 years ago
Solved

Create Running Total On A Calculated Measure

Hi.   I am trying to create a running total for a field that is defined as a Calulated Measure.  Having read numerous posts I am clear about the formula struture which needs to be implemented;   ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi dax_bee,

    Create running total using  the following DAX formula and check if you get desired result.

    RunningTotal = SUMX(FILTER(ALLSELECTED('Calendar'[DateKey]),'Calendar'[DateKey]<=MAX('Calendar'[DateKey])),[my_field])

    If the above Dax doesn’t help in your scenario, please help to share sample data of your  table and post expected result.

    Thanks,
    Lydia Zhang

SaraM's avatar
SaraM
Frequent Visitor
8 years ago

Hi there,

 

I am using this formula to run the total in my table but it doesnt work . it bring the exact same value from the column i am looking to sum.

Column 3 is monthly cost and column 2 is dates.

Do I need to chnage the formula???

 

CUMULATIVE  = CALCULATE (
    SUM ( Phasing[Column3] ),
    FILTER (
        ALL ( Phasing[Column3] ),
        Phasing[Column2] <= MAX ( Phasing[Column2] )


    )
)