New table with averages per month that filter other table

[TommyHerman]

Hi!

I'm trying to create at table based of another table that calculates the average of a column per month that also filters out based on 2 other columns.

My data (this data will be expanded to contain data from way in the past and also new data from months to come)

I would like to create a new table or at least a way to present the average of column [SL 20] by month that is filtered if column [Antal besvarade samtal] or [Tappade samtal] is higher than 0.

My initial tought was to create a calculated table with columns for month and the sum of values in [SL 20] divided by number of rows that are higher than 0 in [Antal besvarade samtal] or [Tappade samtal].

To clarify (example data), the resulting table.

Hopefully someone can help me with this. Or maybe have a better way of accomplishing this.

Best regards,

Tommy Herman

[v-chuncz-msft · Accepted solution]

@TommyHerman,

You may simply try AVERAGEX and FILTER to add a measure.

[TommyHerman]

Thank you @v-chuncz-msft!

With your help I managed to get it working with this folmula, 

= CALCULATE(AVERAGEX(Samtalsstatistik, Samtalsstatistik[SL 20]), FILTER(Samtalsstatistik, OR(Samtalsstatistik[Antal besvarade samtal] > 0, Samtalsstatistik[Tappade samtal] > 0)))

Regards,

Tommy Herman