Identify (filter) context of a table column to avoid unneeded calculations

hello MFelix  , what a great piece of DAX code, Jesus  😂!

I'll try it out and tell something after.

Please allow me just a few comments & outburts ("desabafos", as we say in portuguese):

1- DAX is not easy, this doesn't help end users (namely business users for self service BI...)

2- DAX must be carefully developed, or else is very slow, (so the perspective "let's try to see if this works" many times results in slow reports...)

I end with a question, related with the 2nd point:

is there anyway (considering your code or generally speaking) to refer a (previous) column in a table or matrix, to optimize calculations?

It could be like picking the delta you calculated, and using it in a complex calculation like

( row_columnA * row_columnB / row_columnZ) + (row_columnD *delta)   

without having to calculate delta it again.

Thanks again, Regards.