Reply
Highlighted
Member
Posts: 112
Registered: ‎05-02-2017

Percent of Column Total

[ Edited ]

 

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!)

Member
Posts: 87
Registered: ‎05-21-2018

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
Posts: 1,378
Registered: ‎07-30-2018

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.
Member
Posts: 112
Registered: ‎05-02-2017

Re: Percent of Column Total

I have edited the post

Community Support Team
Posts: 1,378
Registered: ‎07-30-2018

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.
Member
Posts: 87
Registered: ‎05-21-2018

Re: Percent of Column Total

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