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

Anonymous's avatar
Anonymous
Not applicable
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

punitmicrosoft's avatar
punitmicrosoft
New Member
1 year ago

THanks a lot. I also had same query .