cancel
Showing results for
Did you mean:
Highlighted
Member

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

.

.

(hope this is better!)

5 REPLIES 5
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

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]) ).

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

Re: Percent of Column Total

I have edited the post

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.
Member

Re: Percent of Column Total

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

Announcements

Challenge: Can You Solve These?

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

Community News & Announcements

Get your latest community news and announcements.

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.

Win Power BI Swag with Community Kudopalooza!

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

Top Kudoed Authors
Users Online
Currently online: 148 members 1,714 guests
Recent signins: