Percent of Column Total

[Anonymous]

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 😞    .. but it explains my problem, any help??

.

.

(hope this is better!)

[Anonymous]

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

[v-lili6-msft]

Hi@ ThePowerBIQueen

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

[Anonymous]

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. 

[Anonymous]

I have edited the post

[v-lili6-msft]

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