Work out percentage of sales per group by date.

[GlynMThomas]

Hi Guys,

I have some sales data, I need to work out the percentage split per day over different groups so it shows me the percentage split by group for each day. Something like the table below:

Sales | Date            | Group | Percent

£300 | 24/01/2019 | Active | 50%

£300 | 24/01/2019 | EFG     | 50%

£200 | 25/01/2019 | Active | 100%

As you can see, the first day is split 50/50 between two groups. There would be more groups than this but you get the point.

I'm then planning on putting this data in a line graph where the Axis is the Month and year, the legend is the group and the value is the percentage. The plan is to show where what percentages have been invested where over a period of time and allow easy comparison of the groups. At present when I do this it puts the percentages the wrong way. I managed to get this to work in a matrix by selecting percent of column total. I basically want to take that data and stick it in a graph.

[jdbuchanan71 · Accepted solution]

Hello @GlynMThomas 

We would just need a couple measures (you will change the table name to match your model).

First one just to sum the Sales

Sales Amount = SUM ( 'Your Table[Sales] )

Then one that calcualtes the % of total across all groups.

Group % of Total = 
VAR TotalAmount = CALCULATE ( [Sales Amount], ALL ( 'YourTable'[Group] ) )
RETURN 
    DIVIDE( [Sales Amount], TotalAmount )