Earn 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
User | Count |
---|---|
94 | |
83 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |