cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Total/sum working incorrectly

Does anyone knows what's going on here and how to deal with it? 

 

Untitled picture.png

 

Table on the right has data from only one table and everything looks good. Table on the left side has data from two tables and total valus don't add up correctly. PowerBI is summing only by value of Tarifa, and the fact there are, for example, two Interent packages is not taken into the equation. 

 

Here is my model

 

Untitled picture.pnggdf.png

 

Two tables that I'm taking data from - Packages(Paketi) and Clients(Klijenti) - are directly connected with 2way relationship direction. Column Price is original column - no Dax or any other function applying there, and Price per month is calculated column: 

PricePerMonth = Paketi[Price] / Paketi[DurationMonths]

 

I tried with various calculated columns and measures. I searched PBI forum, there were lot's of simmilar issues but not quite like this one

 

1 ACCEPTED SOLUTION
Microsoft
Microsoft

@smatesic

 

I’ve tried it again and it worked in my side. I’ve uploaded my .pibix file here. Could you please take a look at it to see if there is any difference?

Total sum working incorrectly_1.jpg

 

Best Regards,

Herbert

View solution in original post

6 REPLIES 6
Microsoft
Microsoft

@smatesic

 

I’ve tried it again and it worked in my side. I’ve uploaded my .pibix file here. Could you please take a look at it to see if there is any difference?

Total sum working incorrectly_1.jpg

 

Best Regards,

Herbert

View solution in original post

hi i have somehow same problems to get currtect column summurization or rowwise sumurization,

please could u quide me how can i get sum in visual level number from each months.

please check the picture attachedInkedseriousQues_LI.jpg

@Thiyagu PLs look on this

This works now. I used columns from Client and Packages tables, from forcast table which is Crossjoined table I only used date column and I got correct totals. I tried using values from forcast, and totals were wrong again... Nevermind, it works and this issue is solved. Thank you for your help

Microsoft
Microsoft

@smatesic

 

Please try with following measure formula.

Measure = 
SUMX ( Forcasting, CALCULATE ( SUM ( Paketi[Price] ) ) )

Totalsum working incorrectly_1.jpg

 

Best Regards,

Herbert

 

 

It doesn't work. Total Price should be $2000 and with this measure I got millions

Untitled picture.png

 

Also, Anita has 3 Internet packages and in PBI only one is shown. 

 

 

These are my source tables, everything is visible there:

Clients table (Client/Tarifa/DueDate):

 

Mike

Internet1.10.2016
JoseStorage1.9.2016
AnitaIT solutions1.11.2016
DavidCloud services1.2.2017
MikeInternet1.12.2016
MikeInternet1.2.2017
PaulinaBI analytics1.11.2016
AnitaInternet1.1.2017
AnitaInternet2.2.2017
AnitaInternet2.4.2018
AnitaBI analytics1.6.2017

 

Packages table (Tarifa/Price/DurationMonths):

Storage $              50,006
Internet $            100,002
IT solutions $            150,001
Cloud services $            200,003
BI analytics $            500,003

 

 

 

Helpful resources

Announcements
secondImage

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

secondImage

Power BI Women

Join our monthly meetings and learning sessions.

secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors