Sum and Average Columns and Rows (Not counting NA's)

[Whitewater100]

Hello:

I am looking to average certain columns avoiding NA's. I have created a PBI file that has a table with mock data and the results I am hoping to achieve is pasted as an image on the first page.  One issues is trying not to mix numeric values and texts. Any help on how to do this is very much appreciated! PBI attached. 
https://drive.google.com/file/d/1GOLjgD8nmiLQ4ga8ynRQYaQx-5goNqm3/view?usp=drive_link 

[Anonymous]

Hi @Whitewater100 ,

I can't download your pbix file, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

How to Get Your Question Answered Quickly 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.