Reputation: 1
I want to calculate the average of monthly values, based on the filtered names and months. I have a table like this:
It should be the average of the values of the two month periods of the workers. Like John´s september average is 13+29/2 = 21. John´s october average is 42+32/2 = 37, and so on...
I tried several formulas based on this one: CALCULATE(AVERAGE('Table'[Values]), CONTAINSSTRING('Table'[Month]) && 'Table' [Name]) , and it didn´t work out:
Can you help me, how could I modify the formula to return the expected values? Or even suggest an other formula. I would be thankful for any advice.
Upvotes: 0
Views: 188
Reputation: 1
Your L1-regularized logistic regression (a.k.a. Lasso penalty) might pick different subsets of correlated features across runs because L1-regularization enforces sparsity in a somewhat arbitrary way when correlation is present. Zeroed-out coefficients aren’t necessarily “worthless”; they may just be overshadowed by a correlated feature that the model latched onto first.
Upvotes: 0
Reputation: 1
You can get the result when it is done as shown in the image to give the average value from the value part in the stacked bar chart.
Upvotes: 0