Forum Discussion

TJacobs's avatar
TJacobs
Frequent Visitor
8 years ago
Solved

PowerBi cumulative calculation goes wrong

Hi all,   I'm in a loss in this matter, I've tried many DAX formulas and read many forums but unfortunately I didn't found the solution.  This is the issue  I've created a calculated Line Chart...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi TJacobs,

     

    Based on my test, the formula below should work in your scenario. :smileyhappy:

    Sales Cumulative = 
CALCULATE (
    SUM ( 'Blad1 (2)'[Turnover total]),
    FILTER (
        ALLSELECTED('Blad1 (2)'),
        'Blad1 (2)'[Date_Month] <= MAX('Blad1 (2)'[Date_Month]) 
    )
)

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

Hi TJacobs,

 

Based on my test, the formula below should work in your scenario. :smileyhappy:

Sales Cumulative = 
CALCULATE (
    SUM ( 'Blad1 (2)'[Turnover total]),
    FILTER (
        ALLSELECTED('Blad1 (2)'),
        'Blad1 (2)'[Date_Month] <= MAX('Blad1 (2)'[Date_Month]) 
    )
)

 

Regards

TJacobs's avatar
TJacobs
Frequent Visitor
8 years ago

Yep! now it's working! 

Thanks! :)