The above formula works fine, but I want to dynamically reference the current column (in red color in the above formula), i.e. I want something like if ( Column( ColumnNo() ) > 0, but it won't work (as you can see, he ColumnNo returns vertical column numbers rather than horizontal. The RowNo won't work at all (I think it is because the Pivot uses Measure as rows, i.e. it is transposed.
I don't know how to solve your problem (because you indeed are trying to lookup values in rows, not in columns), but you don't have to copy the huge formula - you can put it into a variable, and use that variable in any measure or expression.