Forum Discussion

CTYLKnepper's avatar
CTYLKnepper
New Member
2 years ago
Solved

Attachment Rate in Power BI Desktop

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?

Need Help
Show and Tell
Tips and Tricks
  • lbendlin's avatar
    lbendlin
    2 years ago

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

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.