This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 10%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Hi,
I am using a power BI dataset to prepare a report in Report Builder. There are duplicate rows in the dataset.
I need help to build an expression in Report Builder Tablix to add up values of "Height" for distinct values of "Package". Hence sum should be 110+3+3+34+13+34+69+34 = 297.
I was initially suggested to modify the dataset by an SQL statement, which I am not able to do. So I am trying to build an expression in Report builder without modification to source data. Can that be possible. Please help!
Package Height
A 110
A 110
B 3
B 3
B 3
B 3
C 34
D 13
D 13
D 13
E 34
E 34
F 69
G 34
G 34
Thanks,
Muralidhar
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
It is recommended that you do not focus on processing data in the report designer, you can try to operate in the data source, and finally present it in the report designer. The ROW_NUMBER() function is not suitable for Power BI data sources, but I think there will be a similar way to the ROW_NUMBER() function in Power BI.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 71%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV5%3C/text%3E%3C/svg%3E)
Hello,
Use the column grouping in place of column only. It will solve your issue.
http://www.sqlcircuit.com/2013/09/ssrs-how-to-filter-report-data-at.html
Thanks,
VJ
If the answer is helpful, please click "Accept Answer" and upvote it.
Hi @Murali5431 ,
If you are using PowerBI products, please consult the Power BI Community. You mentioned earlier to create reports in Power Builder. Perhaps you should consult an expert familiar with the product to solve your needs.
Assuming you are using SSRS products, I suggested was that you should go back to the source of the data and perform the operations there and use SSRS to display it. Because indeed I can't think of any other way to achieve your needs. I would be very grateful for any other solutions from other experts. I will attach a link to the previous case and the solution I have proposed：https://learn.microsoft.com/en-us/answers/questions/435220/summing-values-in-column-for-duplicate-rows-in-tab.html
Best Regards,
Joy
If the answer is helpful, please click "Accept Answer" and upvote it.
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.
Thanks for your response! I did post this question in Power BI community, but was not able to get a solution I am looking for (expression to calculate sum).
As most of my queries on Report Builder were obtained from SSRS communities / blogs, I thought of posting my query here.
Thanks again,
Muralidhar
As far as I know, there is no other suitable method in SSRS. At least it is impossible to achieve in the expressions I can think of. But "custom code" is something I'm not good at, and I'm not sure if it is feasible. Any method I can find, I will update it here.