I know this question gets post here a lot but i cant seem to get it working for me.
I Have the folowin data model in SSAS tab:
The table DM_Voorraad contains the inventory data per product, per day. This data is split into total value, quantity an weight for that product at the end of the day and the differerence from the last mutation in the columns delta value, delta quantity and delta weight.
I used the formula:
Total Value = (CALCULATE(sum(DM_voorraad[Delta Value]);