Multiple Columns as Rows with Multiple Calculations of those Columns

Question

I have some data in columns as seen below:

I need this data to appear in a visual like this:

I can't figure out how to make the column headers as rows and then get multiple values from these columns, such as average, count and sum. I have only been able to get a single value like average:

Help, please!

amitchandak · Answer

IBrant , You need to create calculation groups, you have option in model view to create calculation groups
Create three calculation items and use measures for each of columns. use the Expression function to use data from the line level 
&nbsp;
Avg = AVERAGEX(Table,SELECTEDMEASURE())
Count = COUNTX(Table,SELECTEDMEASURE())
Sum = Sumx(Table,SELECTEDMEASURE())
&nbsp;
&nbsp;
I used these two measure and test
Qty Line = Sum(Sales[Qty]) Gross Line = sum(Sales[Gross Sales])
&nbsp;
&nbsp;

Model explorer public preview with calculation group authoring| Measure Slicer: https://youtu.be/VfxfJJ0RzvU
&nbsp;

anonymous · Answer

Hi&nbsp;IBrant&nbsp;,Try selecting the matrix. --&gt; format pane -&gt; Value --&gt; switch values to the row --&gt; row headers --&gt; turn off stepped layout:

Output:

Is this your expected output?
Best Regards,GaoCommunity Support Team
&nbsp;
If there is any post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;&nbsp;to help the other members find it more quickly.If I misunderstand your needs or you still have problems on it, please feel free to let us know.&nbsp;Thanks a lot!
How to get your questions answered quickly&nbsp;--&nbsp;&nbsp;How to provide sample data in the Power BI Forum&nbsp;--&nbsp;China Power BI User Group

ibrant · Answer

This sounds great, but I don't have a calculation group option.&nbsp;

ibrant · Answer

Hi, Gao,&nbsp;Thanks for your response but I need it to look more like this:&nbsp;Also, I do not have a row column that inclues all of the categories like your country column. TIA

anonymous · Answer

Hi&nbsp;IBrant&nbsp;,Please try:1. unpivot these colunms in powerqery:

2. Group by [Attribute]:

If you want create a matrix visual, please select these and unpivot

Best Regards,GaoCommunity Support Team
&nbsp;
If there is any post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;&nbsp;to help the other members find it more quickly.If I misunderstand your needs or you still have problems on it, please feel free to let us know.&nbsp;Thanks a lot!
How to get your questions answered quickly&nbsp;--&nbsp;&nbsp;How to provide sample data in the Power BI Forum&nbsp;--&nbsp;China Power BI User Group