Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
solved on own.
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