DAX Total Issue

[cthariharan]

We are facing an issue in power bi dax query and please let me know if anyone come across or can help us on that.

Thanks in advance.

We have a dataset which has following values after filter selection,

Category                                            Actual

------------------------------------------------

Paint & Liquid Material                         $24,399.12

Paint & Liquid Material                         $25,039.13

When we use the same dataset from dax query to form another dataset It is giving a wrong aggregation (sum).

Value it shows now is, $1,97,513.00

Sum of the above actual columns should be $49,378 ($24,339.12 + @25,039.13)

Without aggregation it shows values properly in dax as well.

[v-yuta-msft]

Hi cthariharan,

Are there some duplicate values in [Actual] column? Could you please give the DAX formula or screenshot about your filter?

Regards,

Jimmy Tao

[Yggdrasill]

Check your filters. This is most likely a human error

[iamprajot]

What is it that you are using. There must be an aggregation mistake.