Forum Discussion

GoodMan85's avatar
GoodMan85
Frequent Visitor
4 years ago

AVG Measures

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

Need Help
Show and Tell

2 Replies

  • MFelix's avatar
    MFelix
    Super User
    4 years ago

    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]
)

     

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Community Support
    4 years ago

    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.