Creating a column with a sum of another column that repeats each row

[nosaj03]

Hey all, 

I am a complete noob at this so accept my apologies in advance if this is a very basic question.

Lets say I have a table of employee sales data for a specific office. 

I want to add a column that shows the total sales of the office so that I can also show what percentage their sales makes up from the total sales of the group.

How do I go about adding the column of total sales?

Every time I use the sum function for sales, it only provides me the sum for the individual employees and not of the group

Any help would be greatly appreciated. 

Employee	Sales	Group Sales	Variance
Emily	10	100	10%
Joe	20	100	20%
Sarah	20	100	20%
Bill	30	100	30%
John	10	100	10%
Lisa	10	100	10%

[kentyler · Accepted solution]

Here you go.

Measure for calculating total sales:

Group Sales Measure = calculate(sum('Table'[Sales]),all('Table'[Employee]))

Measure for calculating variance

Variance Measure = VAR total_sales = [Group Sales Measure]

var individual_sales = selectedvalue('Table'[Sales])

RETURN Divide(individual_sales,total_sales)

I do a little video with commentary soon

[nosaj03]

@kentyler thank you so much for your expertise! It worked with unfiltered data but when the data is filtered ie filtering for a specific group of a company that has many groups, the data only returns the individual sales again.

How do I work around that?

[kentyler]

that would be a variation on the theme

if you'd like to do a screen share to explore the possible solution

email me. i'm ken at 8thfold dot com

other wise please post some sample data, and we'll see if we can work it out

[nosaj03]

@kentyler actually I figured it out. I used the ALLSELECTED function with the names of Employee and group and it worked perfectly. Thanks again for all of your help.!!!!

[kentyler]

Great Work!

[kentyler]

I often feel its hard to provide enough context in a written answer. So here's a little video https://youtu.be/kW6JUh5mQ6I 

[kentyler]

This is what the ALL() function is in DAX for. 

I'll post a sample shortly.