How to sum when filter is based on the row

OK, yeah.  You don't want to create calculated columns in this case.

You just want to create 1 single measure, and add it to your table visual.

It's the same measure I shared originally.

The measure shows how to create VARs within a measure.

You simply use the keyword "VAR", followed by the variable name (any name you like), and then assign the variable whatever value or calculation.

Please create the measure shown (with your table/column references of course) and add it to the table visual.

Regards,

Nathan