Total/sum working incorrectly

[smatesic]

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

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

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

[v-haibl-msft · Accepted solution]

@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?

Best Regards,

Herbert

[rezaieehsan]

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 attached

[Baskar]

@Thiyagu PLs look on this

[smatesic]

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

[v-haibl-msft]

@smatesic

Please try with following measure formula.

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

Best Regards,

Herbert

[smatesic]

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

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	Internet	1.10.2016
Jose	Storage	1.9.2016
Anita	IT solutions	1.11.2016
David	Cloud services	1.2.2017
Mike	Internet	1.12.2016
Mike	Internet	1.2.2017
Paulina	BI analytics	1.11.2016
Anita	Internet	1.1.2017
Anita	Internet	2.2.2017
Anita	Internet	2.4.2018
Anita	BI analytics	1.6.2017

Packages table (Tarifa/Price/DurationMonths):

Storage	$              50,00	6
Internet	$            100,00	2
IT solutions	$            150,00	1
Cloud services	$            200,00	3
BI analytics	$            500,00	3