Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Issue to sum a Measure

Hello, I am building a PBI report, in which I created a DAX measure that simulated a rates in a selected past period. The user selects a period of refrence (1 month) the report displays the total...
Data Protection
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Anonymous ,

Here is a sample from the result I want to get: data sample 
Now, when it comes to displaying the result in a table visual, all good I get the result I want. However, the totals are incorrectly calculated (the actual cost and the simulated rate respective sums are equal).
Same problem using column visuals.

Any advice ?

Thanks,
Olfa

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Anonymous 

     

    Maybe my description is not clear enough for you to misunderstand, I would like you to provide the sample data used in this DAX so that we can figure out the problem and propose a solution more easily. It would be nice if you could provide the pbix file.(In the data provided please remember to remove privacy)

     

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