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

 

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

smatesic's avatar
smatesic
Helper I
9 years ago

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