dax help

[cool_333]

Hi all, I'm trying to calculate 25*108075 = 2701875 instead I'm getting results as 2746186 which is incorrect. I have different categories columns in the table not sure how this is getting filtered, please help.

[v-yueyunzh-msft · Accepted solution]

Hi ,  @cool_333 

According to your description, you want to calculate 25*108075 = 2701875.

It is difficult to see the problem with just a picture. DAX is a statement for filtering context, and different filtering may calculate different results.

According to your screenshot, the values of the first two columns are correct, then to calculate the product, you can create a measure to try, assuming 25 is [Measure1], 108075 is [Measure2]:

Measure3=[Measure1]*[Measure2]

 

If this still can't help you to solve the problem, you can try to give me some test data and expected output similar to your table structure, and how you put the fields in visual to tell me. You can provide it to me as a form, or you can upload your sample pbix file (without sensitive data) to OneDrice and send it to me as a link.

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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