Adding values in column for duplicate rows in Tablix

[murali5431]

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.

Hence sum should be 110+3+3+34+13+34+69+34 = 300.

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

[v-deddai1-msft · Accepted solution]

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