DAX Total Issue

Question

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.&nbsp;We have a dataset which has following values after filter selection,&nbsp;Category &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Actual------------------------------------------------&nbsp;Paint &amp; Liquid Material &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $24,399.12Paint &amp; Liquid Material &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $25,039.13&nbsp;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&nbsp;Sum of the above actual columns should be $49,378 ($24,339.12 + @25,039.13)&nbsp;Without aggregation it shows values properly in dax as well.&nbsp;

iamprajot · Answer

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

yggdrasill · Answer

Check your filters. This is most likely a human error

v-yuta-msft · Answer

Hi&nbsp;cthariharan,&nbsp;Are there some duplicate values in [Actual] column? Could you please give the DAX formula or screenshot about your filter?&nbsp;Regards,Jimmy Tao

Forum Discussion

DAX Total Issue

3 Replies

Related content

DAX Issue

DAX code issue

DAX total != total rows

DAX issue ISBLANK

Basic DAX Issue