Calculate Average of a measure per category

[kamalbandam]

Hi, 
I have the 'Value' as a calculated measure. I want to have the expected as below

Name	Category	value	Avg_Value
a	PO	1	1.5
b	PO	2	1.5
c	PP	0.5	0.5
d	OO	2.5	2.75
e	OO	3	2.75

Please help me with this solution. I think I am clear

Thank you.

[amitchandak]

@kamalbandam , Try

Avgmeasure =calculate(average(Table[Value]),allexcept(Table,Table[Category]))

[kamalbandam]

Hi @amitchandak ,

The  'Value' we are trying to evalute itself is a calculated measure which is not a column. This calculated measure is derived from other table.

[v-chuncz-msft]

@kamalbandam 

You may add measure below.

Measure =
AVERAGEX ( ALLSELECTED ( 'Table'[Name] ), [Value] )

[kamalbandam]

It worked! Thank you very much

How does it work? Can you elaborate