AVG Measures

[GoodMan85]

Hello to all,
I have a series of calculated measures and of these measures I would like to make a simple arithmetic average.

Is there someone who can help me?

From [-12 OH] to [-1 OH] are Measures and I need to calculate the Average. In Figure 1 I have full of Data Sets while in Figure 2 I haven't Date in [-12 OH] to [-9 OH]. In the first case the average must correspond on all the measures while in the second case only on the full ones

[v-chenwuz-msft]

Hi @GoodMan85,

I suggest you use the matrix table

I create some simple data like the following:

And create a matrix table

The result:

If I misunderstood you meaning, please let me know.

Here is my pbix file you can reference.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MFelix]

Hi @GoodMan85 ,

Try the following code:

Average of measures = 
AVERAGEX (
   FILTER( UNION (
        SUMMARIZE ( table, table[itemcode], "@MeasureTotal", [Measure] ),
        SUMMARIZE ( table, table[itemcode], "@MeasureTotal", [Measure 2] ),
        SUMMARIZE ( table, table[itemcode], "@MeasureTotal", [Measure 3] )
    ),[@MeasureTotal] <> BLANK()),
    [@MeasureTotal]
)