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 provided above should work in your scenario. Could you share a sample pbix file which can reproduce the issue, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. :smileyhappy:

 

Regards