calculate average from calculated measure

[SEPA]

Dear Experts,

I have data like below,

country	level	stage	target	actual	stage actual avg	level actual avg	country actual avg
spain	lvl1	stg1	1327	4585	345.60%	229.11%	115.55%
spain	lvl1	stg2	1327	1494	112.61%	229.11%	115.55%
singapore	lvl2	stg9	1667	0	0.00%	0.00%	115.55%
germany	lvl3	stg5	1013	1516	149.61%	117.53%	115.55%
germany	lvl3	stg6	1013	866	85.46%	117.53%	115.55%

I was able to achieve the average of stage and level measure but for country average i am getting different average values.

stage average = average of Arch by stage

level average = average of (stage average) by level

country average = avergae of (level average) by country - this measure is not giving correct vaue. i am getting 138.

Please help

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

Country avg: =
AVERAGEX (
    ADDCOLUMNS (
        FILTER (
            SUMMARIZE ( ALL ( 'Table' ), 'Table'[COUNTRY], 'Table'[LEVEL] ),
            'Table'[COUNTRY] = MAX ( 'Table'[COUNTRY] )
        ),
        "@levelavg", [Level avg:]
    ),
    [@levelavg]
)

[SEPA]

Thank you it works as expected