Forum Discussion

sparkymark75's avatar
sparkymark75
Frequent Visitor
7 years ago
Solved

Using DAX to get a cumulative total using measures

I have the following measures defined in a dataset;   DOAs = CALCULATE(COUNT('Incident'[TicketNumber]),'Incident'[new_installoutcome] = "100000000") FOAs = CALCULATE(COUNT('Incident'[TicketNumber])...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi sparkymark75 

    You may try below measure to get the cumulative total of a measure.For example:

    Measure =
CALCULATE (
    [DOAs],
    FILTER ( ALL ( Incident ), Incident[date] <= MAX ( Incident[date] ) )
)

    Regards,

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi sparkymark75 

You may try below measure to get the cumulative total of a measure.For example:

Measure =
CALCULATE (
    [DOAs],
    FILTER ( ALL ( Incident ), Incident[date] <= MAX ( Incident[date] ) )
)

Regards,