Forum Discussion

bangerz253's avatar
bangerz253
Frequent Visitor
7 years ago
Solved

How to create a new column 'Count divided by Total'?

Hello, I'm looking to add a new column for conversion rate, so divide by count & the column total for specific groups. For Ex. I have WA and it's Successful Installs is 43 & the total is 139 in...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    Download the PBI file from here.

    Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Based on your example do you want a column with this percentage for each month, for totals, or both? 

  • bangerz253's avatar
    bangerz253
    Frequent Visitor
    7 years ago

    Hi, I want a column with a percentage for both pls! Ex. Looking at Nationwide in March for 'Successful' a column beside it would be 8/13=62%, etc for april and may... and then for Total there would be a column beside it being 519/1317= 38%.

     

    Thank you so much if you can help!

  • bangerz253's avatar
    bangerz253
    Frequent Visitor
    7 years ago

    Do you know how I can solve my problem? Anonymous 

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      7 years ago

      Hi,

       

      So you want that calculation for each month but only for the row which reads as Successful installs.  If i am correct, then share the link from where i can download your PBI file.

      • bangerz253's avatar
        bangerz253
        Frequent Visitor
        7 years ago

        Hello Ashish_Mathur ,  I want that calculation for each month of each group (Nationwide, CA, WA, Other) only for the row which reads as Successful installs, defective installs, no installs, and service