Aggregating the value of account after combining the multiple row into one. ?

[Kartic21]

Hi All,

Referring to this video https://www.youtube.com/watch?v=nJ7LzwiSwnw,

My requirement is to show sum of amount after rows are combined .

input 

Pedro	China	63
Pedro	India	268
Pedro	US	239

output,

Pedro     China,India,US  570   

i am able to combine the rows after watching this link https://www.youtube.com/watch?v=nJ7LzwiSwnw,
but not sure how to aggregate the amount to get 570 as total amount

Can some suggest how to reach to the output

[Kartic21]

Hi All,

My requirement is to show sum of amount after rows are combined .

input 

Pedro	China	63
Pedro	India	268
Pedro	US	239

output,

Pedro     China,India,US  570   

Please suggest the ways !!

[Anonymous]

Hi @Kartic21,

You can use below measure formulas to ignore filter effect on column 2 and Concatenate text:

Total Amount based on Column1=
CALCULATE ( SUM ( Table[Column3] ), ALLEXCEPT ( Table, Table[Column1] ) )

Concatenate Text =
CALCULATE (
 CONCATENATEX ( VALUES ( Table[Column2] ), [Column2], "," ),
 VALUES ( Table[Column1] )
)

Regards,

Xiaoxin Sheng

[Anonymous]

USe

Calculate (sum(Column3), ALL(Table  Name))

[Kartic21]

Thanks for reply though This is not working