How can I sum each average value in one measure

[lchi08978]

Hi ,

I have a dataset like below:

I've calculate average 'Duration' group by 'Application'，

DAX: avg_duration = CALCULATE(AVERAGEX('AP tbltimecard_engineering_system',

                                                                        'AP tbltimecard_engineering_system'[Duration]),

                                                      ALLSELECTED('AP tbltimecard_engineering_system'[Year_Week]))

result :

my next step is get sum of each application's average value
sum_average = 0.35 + 0.16 + 0.72 = 1.23

like below，

now I write hard code '1.23' into a measure ,

and I've tried every solution that I know on DAX,but still can't do what I want.

How do i do this?

Thank you for read to here .

[Kishore_Kadhir]

Hi @lchi08978 

Can you try the below measure and see if it works?

Sum of Average =

CALCULATE(

SUMX('AP tbltimecard_engineering_system',

CALCULATE(AVERAGE('AP tbltimecard_engineering_system'[Duration]), ALLEXCEPT('AP tbltimecard_engineering_system', 'AP tbltimecard_engineering_system'[ApplicationName]))

/

CALCULATE(COUNT('AP tbltimecard_engineering_system'[ApplicationName]),

ALLEXCEPT('AP tbltimecard_engineering_system', 'AP tbltimecard_engineering_system'[ApplicationName]))),

ALL('AP tbltimecard_engineering_system'))

Regards,
Kishore

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

[amitchandak]

@lchi08978 , Try a measure like

calculate( AverageX(Values('AP tbltimecard_engineering_system'[Application Name]), [avg_duration ]), allselected())

[lchi08978]

Hi @amitchandak ,

I tried your measure,but the output seems not I want,

result:

did I write something wrong?

and thank you for your reply!

[v-rzhou-msft · Accepted solution]

Hi @lchi08978 ,

I suggest you to try this code to create [avg_duration] measure.

avg_duration = 
VAR _SUMMAZIRE = 
SUMMARIZE (
    'AP tbltimecard_engineering_system',
    'AP tbltimecard_engineering_system'[ApplicationName],
    "avg_duration",
        CALCULATE (
            AVERAGE ( 'AP tbltimecard_engineering_system'[Duration] ),
            ALLEXCEPT (
                'AP tbltimecard_engineering_system',
                'AP tbltimecard_engineering_system'[ApplicationName]
            )
        )
)
RETURN
SUMX(_SUMMAZIRE,[avg_duration])

Result is as below.

Best Regards,
Rico Zhou

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