Example

Here's a simple example to illustrate:

Load the Sales Data:

Import your sales data into Power BI.

Create the Table:

Select the Table from the "Visualizations" pane.

Add Fields:

Drag the "Subcategory" field to the "Columns" area.

Drag the "Sales" field to the "Columns" area.

Drag the "Profit" field to the "Columns" area.

Drag the "Quantity" field to the "Columns" area.

Try following aggregation options

1. Calculate average of profit 

Go to "Build" option under panes  - you will see "Columns" option - Select column in which you want to change aggregation (in our case profit) - click on " > " button to expand options - you will get pop up labelled "Data" - under it select second option "Summarization"  - under summarization dropdown select "Average"- you will get average profit under profits column.

2. Calculate maximum sales 

Go to "Build" option under panes  - you will see "Columns" option - Select column in which you want to change aggregation (in our case sales) - click on " > " button to expand options - you will get pop up labelled "Data" - under it select second option "Summarization"  - under summarization dropdown select "Maximum"- you will get maximum sales under sales column by sorting it in descending order.

3. Calculate percentage of profit

Drag profit from data pane one more time to "Columns" under "Build" pane - this will add profit column to table - now Right click on profit under "Column" option - a drop down list will appear - select "show values as" - select percent of grand total - you will get profit by percentage in the profit column - you can sort in descending order to get maximum profit of respective sub category