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
CApowerbi
Frequent Visitor

Wrong total

Hello!
I reach out to you in hopes to get help here. 

I have tables where the total does not sum up the correct way. See example: 

 

CApowerbi_0-1685000509219.png

 

 

 

 

The red area to the left= The companies in our business. 


As you can see I have highlited the total rows which is not sum up the correct way. 
The "average lönekostnad ex soc" is not supposed to be in the table, but I brought it in here since I use it in the measure for "total lönekostnad ex soc". The total row in "Total lönekostnad ex soc" is multiplying "antal konsulter"=208 x "Average lönekostnad ex soc"=-45001,75. 
This is not correct. I want the "total lönekostnad ex soc" total row to summarize the total for the rows that is over it. 

 

This is the measure I use for the "total lönekostnad ex soc":

Total lönekostnad ex. soc = [Average lönekostnad ex soc][Antal konsulter]


Do you understand my problem? 

Hope that you can help me! 

Best regards! 

1 REPLY 1
johnt75
Super User
Super User

SQLBI have a great article and video on this - https://www.sqlbi.com/articles/why-power-bi-totals-might-seem-inaccurate/ 

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.