Total Sum Not Working

Anonymous · ‎11-23-2020

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 · ‎11-25-2020

@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 · ‎11-23-2020

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 · ‎11-23-2020

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?

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!