dax help

cool_333 — Mon, 31 Jul 2023 19:53:47 GMT

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.

Re: dax help

v-yueyunzh-msft — Wed, 02 Aug 2023 01:30:39 GMT

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.

topic dax help in DAX Commands and Tips

dax help

Re: dax help