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.