Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
jwc
New Member

Using LINESTX with NEW TABLE works, but fails in function for NEW MEASURE

I reviewed an number of posts and videos on how to do linear regression.

 

I can get a regression of "vbat vs ts" to work when i create a new TABLE using the following;

 

Regression = LINESTX('LowPower', [vbat], [ts])

 

And then create a new MEASURE "vbat_lr" using;

 

vbat_lr =
var _m = SELECTCOLUMNS(Regression, [Slope1])
var _b = SELECTCOLUMNS(Regression, [Intercept])
var x = SELECTEDVALUE(LowPower[ts])
var y = _b + _m * x
RETURN y

 

However, other tutorials suggest not using a regression table and embedding the LINESTX function in the MEASURE;

 

vbat_lr =
var _reg = LINESTX('LowPower', [vbat], [ts])
var _m = SELECTCOLUMNS(_reg, [Slope1])
var _b = SELECTCOLUMNS(_reg, [Intercept])
var x = SELECTEDVALUE(LowPower[ts])
var y = _b + _m * x
RETURN y

 

This doesnt work!

My vbat_lr measure gives identical values to vbat (suggesting that _lr has Slope1=1 and Intercept=0)

I would prefer not having an extra table and getting the second method working.
I very new to PowerBI.
Hopefully somebody can see what I am doing wrong with embedding the LINESTX in the measure.

1 REPLY 1
lbendlin
Super User
Super User

SELECTCOLUMNS  will produce a list. You normally need to convert that into a scalar value. In your case the table produced by LINESTX is already a single row table, so your approach may work.

 

Do you have some sample data points from the LowPower table?

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.