LINEST forEach

Hi smpa01 ,

Please try:

Measure = 
var _a = FILTER(ALL('fact'),'fact'[Country]=MAX('fact'[Country]))
return MAXX(CALCULATETABLE(LINEST('fact'[y],'fact'[x]),_a),[Slope1])

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

smpa01 You could create a measure that returns a text table using TOCSV and parse that.

For example:

LINEST Output = 
VAR _filteredTable_ = FILTER ( ALL ( 'fact' ), 'fact'[Country] = MAX ( 'fact'[Country] ) )
VAR _linEst_ = LINESTX ( _filteredTable_, 'fact'[y], 'fact'[x] )
VAR _toText = TOCSV ( _linEst_, , "|", FALSE() )
RETURN
    _toText

Then you can define the following:

Slope1 = PATHITEM ( [LINEST Output], 1 )

ResidualSumOfSquares = PATHITEM ( [LINEST Output], 10 )