Calculating Average Age based on number of licences per age

[Rwcoops88]

Hi,

Im very new with Power Bi, I'm trying hard to learn but struggling with some areas of it. Im trying to generate a card that will show the average age of staff that have a licence. My spreadsheet is similar to the below: 

Age	Number of Licences
24	1
25	0
26	2
27	0
28	1
29	2

When I have tried to use quick measure It doesnt seem to be working correctly however I may be misunderstanding the set up. 

Thanks,

Robin

[Rwcoops88]

[Uzi2019]

What is your expected output???
You shared your input only. we want to understand what do you want to see in the output?
shared expected result by typing into excel.

[Uzi2019]

Hi @Rwcoops88 
Would you please provide input data and expected output you want in simple excel screen shot?
just simple columns and its values in columns

[Rwcoops88]

Im not sure on the figure that will be shown, I want an average age on the licence holders in AGE. I have entered the age 44 as I expect it will be around this age. 

[Uzi2019]

Hi @Rwcoops88 

I have taken your input and done the calculation where it display the average of age when No of License >0.

you can create following formula in measure:

Avg_age = CALCULATE(AVERAGE('Age table'[Age]),FILTER('Age table',SUM('Age table'[No of License])>0))

If I answered your question please give kudos and accept my solution!
Thank you.