cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
saknivi Frequent Visitor
Frequent Visitor

Divide each row with sum of value in column for a particular group

Hi Everyone,

I have 3 columns here N,P,Q. N is the count of families from the families tab. P is to total number of quantity booked for a particular part number. Q is the sum total quantity booked for a part number that belongs to different families. One part can belong to any number of families at a given point.

 pic1.PNG

 

The value of Column Q comes from a Pivot. See attached Screen shot below.

 

 pic2.PNG

 

So what I want to create(column/measure) in Power BI for Attach Rate = Value of Column P ie 24 divide by sum of all the value for that product ie 1894.

Thank you in advance for the help.

3 REPLIES 3
Microsoft v-jiascu-msft
Microsoft

Re: Divide each row with sum of value in column for a particular group

Hi @saknivi,

 

Can you share some original data in text mode that we can copy, please? Please mask the sensitive parts first.

Where is the quantity booked?

 

 

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.
Highlighted
saknivi Frequent Visitor
Frequent Visitor

Re: Divide each row with sum of value in column for a particular group

Hi Please find dummy data attached. The column P ie total Quantity booked comes from a different sheet. I am looking to create the column Attach Rate in Power BI using my above same data. The total Quantity booked comes from the Pivot table logic provided initially.
Thank you for your help!

 

 

Region Shipped From Part Number Family-1 Family-2 Booked Total Booked  Attach Rate
APAC       X                        101               AA         AB           24           1894          0.012671595
APAC      Y                        101              AA          AB            6            1894           0.003167899
APAC    WW                     101              AA           AB          30            1894           0.015839493
NA           A                       101             AD           AC           272          6074          0.044781034
NA           B                       101            AD            AC            52           6074           0.00856108
NA          WW                   101            AD             AC          324          6074           0.053342114

Microsoft v-jiascu-msft
Microsoft

Re: Divide each row with sum of value in column for a particular group

Hi @saknivi ,

 

Can you share the original format data, please? Please mask the sensitive parts. Your sample here is the aggregated data. If you have such data, you can get the rate easily like below.

 

Column = [Booked] / [total Booked]

 

 

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
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors