Attachment Rate in Power BI Desktop

[CTYLKnepper]

Hello! I'm pulling in data from a Sharepoint list into Power BI in hopes of streamlining the process in finding our "attachment rate" with our client base. 

In the image below, ACME Inc and ABC Co utilize a certain percentage of our products ("primary") and a certain percentage they keep in house ("retained"). 

If the data before the yellow highlight is put into Power BI, how do I have it generate the yellow highlighted calculation?

[Anonymous]

Hi  @CTYLKnepper ,

Have you solved your problem? If it's solved, you can mark the correct answer, if not, provide more detailed information and we can help you better!

Best Regards,

Liu Yang

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

[lbendlin · Accepted solution]

Read about unpivoting.  Once your data is in a usable format you can then use measures to calculate the ratios.