DorottyaB.H.
DorottyaB.H.

Reputation: 1

Calculating average with multiple filters

I want to calculate the average of monthly values, based on the filtered names and months. I have a table like this:

Table

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

Answers (3)

Hui Tang
Hui Tang

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

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.

enter image description here

Upvotes: 0

NaHolla
NaHolla

Reputation: 103

calculate(AVERAGE('Table'[Values]),all('Table'[Period]))

enter image description here

Upvotes: 0

Related Questions