Total Sum Not Working

[Anonymous]

Hi guys, 

I have a table in which I am looking to obtain the full amount based on date however when I add the sum, it seems to just take an average (as displayed below).

PBI Table

Can someone please tell me the formula to get the correct total? I have tried a sumx but it doesnt seem to work either.  

Thanks in advance!

[V-pazhen-msft]

@Anonymous 
If the DPI is a column in your data, just try create a measure = sum([DPI]), then add to the table visual. 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Anonymous]

what sample data would you require? I would expect this to be output as £222k for the total, I can't seem to get it to work for the overall sum on a table. 

[vanessafvg]

can i ask how you getting the total currently?  odd that it wouldn't sum it up properly, how is the sum on the rows being calculated?  

[Pragati11]

Hi @Anonymous ,

Share some sample data and expected output so that we can help further.