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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
ImPalaBI
Helper I
Helper I

TOTAL of column showing wrong value

I have a formula that multiplies two columns. I use it in a table visual, but dont get the expeted value (I want the sum of the meassure, but I get the multiplication of the sums of the columns):

capture2.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

I added a hardcoded column with the sames values to show the expected value.

 

Thanks in advance!

2 REPLIES 2
MattAllington
Community Champion
Community Champion

Read my article here. Take not of the section "totals don't add up" towards the end of the article. 

https://exceleratorbi.com.au/use-sum-vs-sumx/



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

Thanks! That worked! (it is a bit slower, but nothing to worry)

capture2.png

 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.