Forum Discussion

IliasIdrissi_99's avatar
IliasIdrissi_99
Regular Visitor
3 years ago
Solved

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 fi...
Need Help
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    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.

v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

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_99's avatar
IliasIdrissi_99
Regular Visitor
3 years ago

Thank you, this is what i was looking for!