How to sum multiple columns

[kaytrishjr]

I am trying to sum multiple columns (in Yellow). These are different workbooks. 

[smpa01]

@kaytrishjr  provide a sample pbix

[filipeoliveira · Accepted solution]

Have you tried to use SUMX? Something like:

MeasureName = SUMX(TableName, TableName[column a] +TableName[column b] +TableName[column c] ...)