Sum of number of columns based on variable

[Anonymous]

Does anyone knows how to write in DAX to tell power bi to add up all of the values in the range of cells that is determined by the value of the cell "LT" in the same row

[amitchandak]

@Anonymous , Please check the reply from @TomasAndersson  first. If that does not help .

I think double = is causing it 

for var you need code like

=

var _variable = sumx(Table, [Value])

return

_variable

[TomasAndersson]

Hi!
If you are able to change the structure of your data the easiest way would be to make your table long instead of wide so that you only have four columns, "Demand...", "LT", "Variable","Value".

You can do that in Power Query if you go to the model view, select Edit query and then under Transform select "Unpivot columns" with all your columns with values selected:

If you control your data source you might be able to do it there as well.

Then you could only use a simple SUM(Value) to find the totals.