Forum Discussion
Creating a cumulative measure based on fixed values
Hi,
i'm having problems with creating a cumulative/running total measure.
My situation is that i have two measure:
First one
Second one
The second measure is similar to the first one but on certain periods i had to force some values based on a field of the calendar table.
My goal was to create a cumulative measure based on the fixed measure (second one), so i created something like this:
here is what i get:
the first row of the cumulative measure is correct, but then it's like that the measure rather than getting the values from the fixed measure, goes to get the value from the first one
How can i resolve this? If something is not clear i'm willing to answer your questions.
Thanks in advance.
Hi IliasIdrissi_99 ,
Please try:
Cumulative Measure = SUMX ( FILTER ( ALLSELECTED ( an_calendario[EOMONTH_DATE] ), [EOMONTH_DATE] <= MAX ( 'an_calendario'[EOMONTH_DATE] ) ), [Fixed Measure] )Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- v-jianboli-msftCommunity Support
Hi IliasIdrissi_99 ,
Please try:
Cumulative Measure = SUMX ( FILTER ( ALLSELECTED ( an_calendario[EOMONTH_DATE] ), [EOMONTH_DATE] <= MAX ( 'an_calendario'[EOMONTH_DATE] ) ), [Fixed Measure] )Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- IliasIdrissi_99Regular Visitor
Thank you, this is what i was looking for!