Sum of add total does not work

Question

HI,

I can't get a "sum" function to work in Power BI Paginated Reports. Anybody who can help or explane why this is not working?
I've a dataset from a REST API Json file in power BI and exported it as a PowerBI dataset. For example,
in power Query the field is a "Whole number"

So i can not select "Add total" or make a expression like "=sum(Fields!...)

Anybody having a idea?

Answer 1

Hi @Nick Budel ,
By default, a total is the sum of the numeric, non-null data in a group or in the data region, after filters are applied. To add totals for a group, click Add Total on the shortcut menu for the group in the Grouping pane. To add totals for an individual cell in the tablix body area, click Add Total on the shortcut menu for the cell.
The Add Total command is context-sensitive and enabled only for numeric fields. Depending on the tablix cell that you select, you can add a total for a single cell by selecting a cell in the tablix body area or for the entire group by selecting a cell in the tablix row group area or the tablix column group area.
In your case, you need to consider two situations:

1. Select the cell of the field to be calculated ,or the grouping in the row group, right-click "Add total", instead of selecting it in a blank cell;
2. Make sure that the field is a numeric field.
   For more information, please refer to: Adding totals to a report.
   The above content is used in SSRS reports. If you need help from PowerBI experts, you could submit your issue at the link below: https://community.powerbi.com/
   Best Regards,
   Joy

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi Joy,

Thank you for your answer. It has been solved.