Forum Discussion

smatesic's avatar
smatesic
Helper I
9 years ago
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...
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    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

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

smatesic

 

Please try with following measure formula.

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

 

Best Regards,

Herbert

 

 

  • smatesic's avatar
    smatesic
    Helper I
    9 years ago

    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

    		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