Need Help Formatting Table Columns

[AColan]

Prefacing this by saying this is my first post to a forum like this, so if you need more clarifications let me know. I also had to make this example because I have a rough format of this on Power BI but I cannot post the specfics here.

I want to make a table that shows a summary of an employee's sales, separated by In Person and By Phone sales methods.

That would look like the above picture in Power BI. The Total Sales column would count up the amount of Phone method sales and In Person sales, respective to the Employee ID. The same would be for Average Price of Sales and Total Money Earned.

The summary would get the data from a spreadsheet, with the data formatted as below.

The one problem I've run into was having In Person and By Phone show up on the same table and be on the same line for 1 Employee ID

Thanks in advance,

AC

[v-xulin-mstf · Accepted solution]

Hi, @AColan

1.Depend on the data you have applied, I create the table below.

2.Create a Matrix as below.

3.Create two measures as below:

Total sales =

COUNT(Table1[Method])

Avarage price of sales =

AVERAGE(Table1[Price])

4.Calculate the sum of price and rename it to Total Money Earned.

5.Drag all columns into Matrix.

Here is the demo, please try it: Need Help Formatting Table Columns

Best Regards,

Link Chen

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

[Ashish_Mathur]

Hi,

To your matrix visual, drag Method to the column labels & Employee ID and Date to the row labels.  Write this measure

Measure = sum(data[price])

Hope this helps.