cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cthariharan Frequent Visitor
Frequent Visitor

DAX Total Issue

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.

 

3 REPLIES 3
iamprajot Established Member
Established Member

Re: DAX Total Issue

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

Re: DAX Total Issue

Check your filters. This is most likely a human error

Community Support Team
Community Support Team

Re: DAX Total Issue

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

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)