How to Take Sum of Any Numeric Value to Group by row items in Paginated report

[jay_patel]

Hello All,

Below is the images from both (Power Bi Desktop & Paginated Report). Applied same filter in both tools.

In power Bi Desktop it's taking only single row item by Grouping using 'Qty' or 'Sum of Quantity' but in paginated report its taking unique for all.

Need to take only single row item like in Desktop.

[v-kkf-msft · Accepted solution]

Hi @jay_patel ,

1. Please add Row Group: Row Group -> Group Properties -> Add -> Group on: [Date] & [ID].

2. Modify the formula of [Value]:

=Sum(CInt( Fields!Value.Value))

3. Run.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.