Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Naveen29
Helper I
Helper I

DAX help

when summing the values in the table (referring the last column(37.25 value) ) , it is summing horizontally instead of vertically . Ex as below:

 

How to fix such issues?

 

Naveen29_0-1660328344905.png

 

1 ACCEPTED SOLUTION
v-jingzhang
Community Support
Community Support

Hi @Naveen29 

 

Is the last column from a measure or a column? Can you please show the DAX code of it?

 

In addition, the solutions introduced in the following blog and video may be helpful. 

Why Your Total Is Incorrect - A Key Power BI Advanced Concept (enterprisedna.co)

What to Do When Power BI Totals are Wrong – business intelligist

 

Best Regards,
Community Support Team _ Jing

View solution in original post

2 REPLIES 2
v-jingzhang
Community Support
Community Support

Hi @Naveen29 

 

Is the last column from a measure or a column? Can you please show the DAX code of it?

 

In addition, the solutions introduced in the following blog and video may be helpful. 

Why Your Total Is Incorrect - A Key Power BI Advanced Concept (enterprisedna.co)

What to Do When Power BI Totals are Wrong – business intelligist

 

Best Regards,
Community Support Team _ Jing

ChristianDGreat
Resolver I
Resolver I

What is this column calculating? Usually you can solve this by using SumX and Summarize.

ChristianDGreat_0-1660329934939.png

 

Thanks

Chris

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.