Problem with Average of a Count

Question

I have this data set that I used for a pivot table in Excel in which it counts the number of projects per practice:&nbsp;&nbsp;# of Completed Projects Per Practice&nbsp;&nbsp;202020212022&nbsp;YES&nbsp;668&nbsp;Verif - DVT5&nbsp;1&nbsp;Verif - HAV543&nbsp;Systems897077&nbsp;Silicon IP&nbsp;&nbsp;2&nbsp;DI438&nbsp;AMS Design&nbsp;&nbsp;1&nbsp;AMS Verif&nbsp;&nbsp;3Total10983103&nbsp;&nbsp;And I want to get the average of this count&nbsp;&nbsp;Avg # of Projects&nbsp;&nbsp;YES&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;Verif - DVT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;Verif - HAV&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;Systems&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 79&nbsp;Silicon IP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;DI&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;AMS Design&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;AMS Verif&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;

jihwan_kim · Answer

Hi,
Please check the below picture and the attached pbix file whether it suits your requirement.
&nbsp;

&nbsp;
&nbsp;
&nbsp;

anonymous · Answer

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

v-easonf-msft · Answer

Hi，&nbsp;Anonymous&nbsp;
Did&nbsp;Jihwan_Kim&nbsp;‘s solution not work for you?
If your problem has been solved,&nbsp;you could accept the helpful answer as solution.
If you still need help, please share more details.
&nbsp;
Best Regards,Community Support Team _ Eason

Forum Discussion

Problem with Average of a Count

3 Replies

Related content

Average - Distinct Count

Counting nulls

Problem with Average

Logic problem?

Accumulated average

	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