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
Solved! Go to Solution.
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
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
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):
Packages table (Tarifa/Price/DurationMonths):
|IT solutions||$ 150,00||1|
|Cloud services||$ 200,00||3|
|BI analytics||$ 500,00||3|
This is a must watch for a message from Power BI!
Click here to read more about the December 2020 Updates!
Click here to read the latest blog and learn more about contributing to the Power BI blog!
Mark your calendars and join us for our next Power BI Dev Camp!.