DAX expression for getting summary for groups of data in rows and not columns

[jaysam]

Hello, 

I will like to get summaries of various groups for multiple columns in this data. I will like to get and display them in rows (preferrably below each data group) and not columns. From my research so far, I have come across the SUMMARIZE formula but I have not been able to get it to achieve the desired outcome. 

Can you please help with available options to get the desired outcome?

Thank you.

Manually prepared table showing desired outcome:

Where I am stuck so far on Power BI Desktop:

Sample pbix with data available here:
https://drive.google.com/file/d/1T6BT8vGruPsXlyUhv2rWPZW3i7MYPh1h/view?usp=share_link

[andhiii079845]

In my opinion you are not able to create easy this summerize column like "Test 1 mean".

This is not a regular function in Power BI.