Calculating average of a measure

[Anonymous]

HI all,

I'm currently looking to calculate the average of a measure, specific to each category to create cards as below.

I have easily created these values by doing the calculations in excel, with the following formulas (in spoiler)

Spoiler

'Outcome' Void/Canx Count =(COUNTIFS('Pols Outcome'![Canx/Void Col],"Void",'Pols Outcome'![Category Col],$A2)+COUNTIFS('Pols Outcome'![Canx/Void Col],"Canx",'Pols Outcome'![Category Col],$A2))

'Pols Incept' Incept Count =SUMIF('Pols Incept'![Category Col],$A2,'Pols Incept'![NoIncepted Col])

Therefore to get an average of each Cat, I could divide the two against each other, or written in longer form, do the following. 

Cat. Avg. ADV % =(COUNTIFS('Pols Outcome'![Canx/Void Col],"Void",'Pols Outcome'![Category Col],$A2)+COUNTIFS('Pols Outcome'![Canx/Void Col],"Canx",'Pols Outcome'![Category Col],$A2))/SUMIF('Pols Incept'![Category Col],$A2,'Pols Incept'![NoIncepted Col]).

I've tried to re-create similar in PBI, however I'm unable to take the average of the measure I've created, which is ADV% 

"ADV% = DIVIDE([Canx + Void Vol.],[Incept Vol.])". Ideally I'd filter this with just a category but it doesn't allow me to change the format to an average! 

Any help would be greatly appreciated! 

Kind regards,

Jordan 

[Anonymous · Accepted solution]

Hi all,

Seems AverageX combined with Values solved my problems!

Examples below. "ADV%" is the measure I'd already created.

AverageX of Cat = AVERAGEX(VALUES(Brokers[Cat.]),[ADV%])

AverageX of Product = AVERAGEX(VALUES('Products'[Product Type]),[ADV%])

Thanks for your help as usual!

[Greg_Deckler]

This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

[amitchandak]

@Anonymous ,

This should help you : https://community.powerbi.com/t5/Desktop/Percentage-of-subtotal/td-p/95390