cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Percent of Column Total

 

Table 1:

SalesPerson              Sales Count       Sales w/Discount

Smith, Willard                 25                          10

Winfred, Oprah               42                            5

Malone, Diane                60                            3

 

 

Table 2:

Discount Name        Sales Count           % of Total Sales

2 for 1                         100

5 for 3                         27                      

 

% Total Sales = divide( [Total Sales] , 'Table 1' [Sales Count Sum])

 

Sales Count Sum = Sum(Sales Count)

 

 

 

English DAX Smiley Sad    .. but it explains my problem, any help??

 

 

 

 

 

 

 

 

 

 

.

.

(hope this is better!)

5 REPLIES 5
Moscuba Member
Member

Re: Percent of Column Total

The output examples do not describe enough for me. I need to see a sample data set from each table. I assume there is a common unique ID to link to. Based on the example, the Discount name has to link to the User table meaning the discount code should be in their or the user ID would need to be in the Discount table. If that is the issue but I'm guessing. 

Community Support Team
Community Support Team

Re: Percent of Column Total

 
your format % Total Sales = divide( [Total Sales] , 'Table 1' [Sales Count Sum])
if you want to add a calculate column by it , you need to create relation between Table1 and Table2
or you want to add a calculate measure by it, you need a measure =SUM(Table1[Sales Count])  instead of  'Table 1' [Sales Count Sum]
like : % Total Sales = divide( [Total Sales] , SUM(Table1[Sales Count]) ).
 
If it is not your case, please share some data sample and expected output. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.
 
Best Regards,
Lin
Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Percent of Column Total

I have edited the post

Community Support Team
Community Support Team

Re: Percent of Column Total

hi,@ThePowerBIQueen 

   We don't find any changed in the post , weather you forgot to save what you had edited ,so please edit the post again to  give us more

details to solve it .thank you .

 

Best Regards,
Lin
Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Moscuba Member
Member

Re: Percent of Column Total

Hummm..Seems you Edited the data examples and deleted the Question. 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 103 members 1,371 guests
Please welcome our newest community members: