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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Question about making a measure

Hello,

I am looking to make a measure where the equation is along the lines of:

 

x = a*b

y = x/sum(b)

 

then I need sum of Y's. I think that the confusing part comes in the form that I can't make a column because the sum(b) need to change with filters to give it a weighted value. Does the solution involve multiple measures and using the calculate function?

 

Just looking for a nudge in the right direction.

 

Thanks

3 REPLIES 3
Anonymous
Not applicable

solved on own.

ppm1
Solution Sage
Solution Sage

Please see this article.

Simple linear regression in DAX – XXL BI

 

Pat

Microsoft Employee
Anonymous
Not applicable

Hey Pat, not using Linear Regression, doing a weighted calculation, I just used those variables because I can't use the real data. 

Thanks,

Chris

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.