Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
The value of Column Q comes from a Pivot. See attached Screen shot below.
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.
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
Hi @Anonymous ,
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,
Hi @Anonymous,
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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |