Average of calculated measure within category

[alisongreen902]

I need help with calculating the average of a calculated measure(% of compliance) by manager. For Joe, I would expect the average to be (38.6+94.4/2=66.5%). I tried using the quick measure function in Power BI, but it looks like it would summarize my spend (1255+850)/(3255+900)=50.7% which is not what I want. 

Category Name	Manager	Complying Spend	Non-Complying Spend	Total Spend	% of Compliance
Tosca	Joe	1255	2000	3255	38.6%
Merlot Villas	Joe	850	50	900	94.4%
Bella Vista	Alison	1570	350	1920	81.8%
Avon dale	Alison	1580	250	1830	86.3%
Long Pine	Alison	75	255	330	22.7%
			Joe	66.5%
			Alison	63.6%

[Nathaniel_C]

Hi @alisongreen902 ,

Try this"

average by mgr = CALCULATE(AVERAGE('Table'[% of Compliance]),ALLEXCEPT('Table','Table'[Manager]))

or this 

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel 

[alisongreen902]

If " % of compliance" is not a column but a measure, how would I incorporate that in?

[Nathaniel_C]

Hi @alisongreen902 ,
Here you go.

Mgr % Compliant Spending = 
VAR _mgrAverage =
    AVERAGEX ( MgrComp, DIVIDE ( MgrComp[Complying Spend], MgrComp[Total Spend] ) )
    
RETURN
    CALCULATE ( _mgrAverage, ALLEXCEPT ( MgrComp, MgrComp[Manager] ) )

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel