Problem with Average of a Count

[Anonymous]

I have this data set that I used for a pivot table in Excel in which it counts the number of projects per practice: 

# of Completed Projects Per Practice

	2020	2021	2022
YES	6	6	8
Verif - DVT	5		1
Verif - HAV	5	4	3
Systems	89	70	77
Silicon IP			2
DI	4	3	8
AMS Design			1
AMS Verif			3
Total	109	83	103

And I want to get the average of this count 

Avg # of Projects

YES	7
Verif - DVT	3
Verif - HAV	4
Systems	79
Silicon IP	2
DI	5
AMS Design	1
AMS Verif	3

[Jihwan_Kim]

Hi,

Please check the below picture and the attached pbix file whether it suits your requirement.

[Anonymous]

I'm trying to get the dax for the second table

[v-easonf-msft]

Hi， @Anonymous 

Did @Jihwan_Kim ‘s solution not work for you?

If your problem has been solved, you could accept the helpful answer as solution.

If you still need help, please share more details.

Best Regards,
Community Support Team _ Eason