Forum Discussion

uscmea's avatar
uscmea
Frequent Visitor
6 years ago
Solved

Dynamic Cumulative Sum

Hi, I have constructed a cumulative measure (called OBJ Cumulative) with the following formula:   OBJ Cumulative = CALCULATE ( SUM (OBJ[Matrículas] ), FILTER ( ALLSELECTED ( Mes_Internacional...
Data Protection
Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, uscmea 

     

    You may try to modify 'ALLSELECTED' with 'All'. Here is my test. The column 'Matriculas' is from OBJ Table. I put it in the same table for test.

     

    OBJ Cumulative = 
CALCULATE (
    SUM (Mes_Internacional[Matriculas]),
    FILTER (
        ALL(Mes_Internacional ),
        ISONORAFTER (
                Mes_Internacional[Num Mes Internacional_Conv], MAX ( Mes_Internacional[Num Mes Internacional_Conv] ), DESC
        )
    )
)

     

     

    Result:

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, uscmea 

 

You may try to modify 'ALLSELECTED' with 'All'. Here is my test. The column 'Matriculas' is from OBJ Table. I put it in the same table for test.

 

OBJ Cumulative = 
CALCULATE (
    SUM (Mes_Internacional[Matriculas]),
    FILTER (
        ALL(Mes_Internacional ),
        ISONORAFTER (
                Mes_Internacional[Num Mes Internacional_Conv], MAX ( Mes_Internacional[Num Mes Internacional_Conv] ), DESC
        )
    )
)

 

 

Result:

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

uscmea's avatar
uscmea
Frequent Visitor
6 years ago

Thank you very much for your help! By changing ALLSELECTED for ALL, my formula works perfectly fine 🙂