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,

I am using this formula in my tables for running totals on column **bleep** from coulmn 3 with dates in coulmn 2 but it doesn't seem to work. it bring the exact value as coulmn 3 and not totals. Is there anything that i need to change ?

 

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