Forum Discussion

99_pct's avatar
99_pct
Frequent Visitor
1 year ago
Solved

Cumulative calculation stopped working when using data model in the service

I have a report (let's call it 'User Report') which uses a dataset from a PowerBI semantic dataset (let's call that one 'Source Report') already in the workspace/service.    In the Source Report I ...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Thanks for GilbertQ's concern about this issue.

     

    Hi, 99_pct 

    First, you can test if it works by changing the DAX to what GilbertQ  recommends, or the DAX I provide below below:

     

    Cumulative Budget = 
    SUMX(
        FILTER(
            'Month list',
            'Month list'[Month] <= EARLIER('Month list'[Month])
        ),
        'Actuals vs Budget'[Budget]
    )
    

     

     

    Secondly you need to make sure that the [Month] field is formatted and of the correct type. Because it is not a date field, Power BI may handle it differently on the server side than on the desktop. You can try converting the [Month] field to a date type or make sure it is consistent across all reports.

     

    Or try deleting and recreating the metric in the Source Report and User Report, which can sometimes reset the potential problem.

     

    Sometimes caching issues can also cause inconsistent data, try clearing your browser cache.

     

     

    I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
    Best Regards,
    Fen Ling,
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.