Forum Discussion
Solved
Total/sum working incorrectly
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 table...
Please try with following measure formula.
Measure = SUMX ( Forcasting, CALCULATE ( SUM ( Paketi[Price] ) ) )
Best Regards,
Herbert
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 |