Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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% |
Solved! Go to Solution.
Here you go.
Measure for calculating total sales:
Help when you know. Ask when you don't!
Here you go.
Measure for calculating total sales:
Help when you know. Ask when you don't!
@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?
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
Help when you know. Ask when you don't!
@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.!!!!
Great Work!
Help when you know. Ask when you don't!
I often feel its hard to provide enough context in a written answer. So here's a little video https://youtu.be/kW6JUh5mQ6I
Help when you know. Ask when you don't!
This is what the ALL() function is in DAX for.
I'll post a sample shortly.
Help when you know. Ask when you don't!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |