Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

The multiple number shows incorrect

Hi,

 

My dax measure is 

Possible  = [Difference]*[pound], the result is incorrect.
pound is the first number and the difference is the second number, but when multiplying them, their result is incorrect.
What is the issue with it?
Thanks!

 

General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

2 Replies

  • PaulDBrown's avatar
    PaulDBrown
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Possibly because of the rounding of decimals.

    1. 10,146.2 * 8.57 = 86, 952.934
    2. 10,146.2 * 8.5665 = 86,917.4223

    So I suspect the result is actually correct.

     

  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, Anonymous 

     

    This situation should be related to your source data. Are both Difference and pound Measure? From what operation are they derived? Can you provide some sample data or simple pbix files? Sensitive information can be removed in advance. 

     

    Best Regards,

    Community Support Team _Charlotte

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