Cumulative Total by SKU, reset by each store

[jbuzaglu]

Hi all, 

I have the following dynamic table, that changes as I change dates:

I wish to have a measure with the cumulative total of those SKUs, by store name. 

The main issue I am having is that the Units measure is not compatible with SUM function, since this is a live connection.

Any help is super appreciated 🙂

[jbuzaglu]

thank you for the file and the response Jing. However when I input the measure, I get an eternal loop. And it doesnt recognize the data. 😞

[v-jingzhang]

Hi @jbuzaglu 

You could try this measure

Cumulative Units = SUMX(FILTER(ALL('Table'[SKU]),'Table'[SKU]<=MAX('Table'[SKU])),[Units CY])

In my sample file, [Units CY] is a simple measure with SUM: Units CY = SUM('Table'[Units]). 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.