Forum Discussion

Lyssillic's avatar
Lyssillic
Helper I
6 years ago

Calculate Running Total Using Measures

I'd like to create a column that calculates the running total of a measure. It's a bit more complicated than that, because it uses two measures: Over and Under. If the previous Over > 0, then add it ...
Need Help
ImkeF's avatar
ImkeF
Community Champion
6 years ago

Hi

there is usually no use for measures in calculated columns.

That's because calculated columns are calculated/refreshed when you refresh the data model to catch changes in the underlying data. 

Measures on the other hand respond to user interactions with the reports.

So if you want to create a column with DAX it's best practice to do this with column operations only.

 

  • Lyssillic's avatar
    Lyssillic
    Helper I
    6 years ago

    ImkeF Okay, could you help me translate this into a calculated column? Also, I'm restricted to only use DirectQuery.