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

Sunkari's avatar
Sunkari
Responsive Resident
9 years ago

dax_bee: What's the logic of my_field.

dax_bee's avatar
dax_bee
Frequent Visitor
9 years ago

Hi.

 

The logic of my_field is very complicated and consists of references to a number of other columns.  So ideally I do not want to replicate within the Running Total logic.

  • Sunkari's avatar
    Sunkari
    Responsive Resident
    9 years ago

    Hmm. As don't the exact logic of my_field, if possible try to push that logic at ETL(Power Query) level and use that column in sum function.