cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
sccoleman1189 Regular Visitor
Regular Visitor

Calculating percentage based on information from multiple tables

Hello,

 

I am trying to calculate the percentage of specific groups (buckets) based on the number of orders. Buckets and orders are from 2 different tables.

 

Buckets contains multiple groups that is a column in my category table. 

Orders is a measure that I created counting the distinct number of ids from my prod table.

 

Instead of creating a measure for each bucket, I wanted to know if there is a way to just create a DAX in that could divide the number of orders based on each category.

 

Below, I was able to just grab my bucket column (value field) and date (rows) and created a matrix. I would like to see the year populated with the percentage numbers. 

 

Capture.JPG

I hope I have clearly explained what I am looking for. Also the two tables have a relationship based on different columns.

1 ACCEPTED SOLUTION

Accepted Solutions
v-jiascu-msft Super Contributor
Super Contributor

Re: Calculating percentage based on information from multiple tables

Hi @sccoleman1189,

 

Where are the Years from? Maybe you can try the formula below and refer to the snapshot.

Measure = count('OrderTable'[Order ID-Prod])

Calculating-percentage-based-on-information-from-multiple-tables

 

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
Super User
Super User

Re: Calculating percentage based on information from multiple tables

@sccoleman1189 please provide the sample data to get you the solution.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





v-jiascu-msft Super Contributor
Super Contributor

Re: Calculating percentage based on information from multiple tables

Hi @sccoleman1189,

 

Please share a sample that we can copy with or download. Please mask the sensitive parts first. The percentage relates to two parts, numerator and denominator. What are they?

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
sccoleman1189 Regular Visitor
Regular Visitor

Re: Calculating percentage based on information from multiple tables

Below is an example of the data. 

 

Order ID and Job Code are in the same table, Bucket is in another table. The tables are joined via job code.

 

I want to calculate the percentage of orders based on each bucket.

 

Order ID-ProdBucket-CategoryJob Code-Prod
AInstallxyz
BRepairqrs
CInstallxyz
DCommercialfgh
ECommercialdef
FInstalllmn
GCommercialabc
HRepairtuv
v-jiascu-msft Super Contributor
Super Contributor

Re: Calculating percentage based on information from multiple tables

Hi @sccoleman1189,

 

Where are the Years from? Maybe you can try the formula below and refer to the snapshot.

Measure = count('OrderTable'[Order ID-Prod])

Calculating-percentage-based-on-information-from-multiple-tables

 

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-jiascu-msft Super Contributor
Super Contributor

Re: Calculating percentage based on information from multiple tables

Hi @sccoleman1189,

 

Could you please mark the proper answers as solutions?

 

 

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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: 256 members 2,815 guests
Please welcome our newest community members: