Forum Discussion
murali5431
Helper III
5 years agoAdding values in column for duplicate rows in Tablix
Hi, Can you help me build an expression in Report Builder Tablix for below requirement? Data is as below. I need an expression to add up values of "Height" for distinct values of Package. He...
- 5 years ago
Hi murali5431 ,
Please use something like:
Measure = SUMX(SUMMARIZE('Table','Table'[Package],"_height",MAX('Table'[Height])),[_height])If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
v-deddai1-msft
Community Support
5 years agoHi murali5431 ,
Please use something like:
Measure = SUMX(SUMMARIZE('Table','Table'[Package],"_height",MAX('Table'[Height])),[_height])
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai