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

[bangerz253]

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 April. I want a new column that says 31%? Like CA in April it has 216 successful and 508 total, so the new column would say 42%! 

Thank you for helping me!

[Anonymous]

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

[bangerz253]

Do you know how I can solve my problem? @Anonymous 

[Ashish_Mathur]

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]

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

[Ashish_Mathur]

Hi,

Share the link from where i can download the PBI file.

[bangerz253]

@Ashish_Mathur  Hello Ashish, are you able to resolve my problem? I am really appreciative! 

[Ashish_Mathur]

Hi,

That is not a downloadable PBI file.

[bangerz253]

@Ashish_Mathur https://uwnetid-my.sharepoint.com/:u:/r/personal/ple4806_uw_edu/Documents/KeyforBusinessDashboard%20...

[Ashish_Mathur]

Hi,

That takes me to a sign-in page.  Upload the file to Google Drive and share the download link here.

[bangerz253]

@Ashish_Mathur https://drive.google.com/file/d/1CEiyreLeQtbUyS0_2oSOUCA8T38Jyenp/view?usp=sharing

okay this should work!

[Ashish_Mathur · Accepted solution]

Hi,

Download the PBI file from here.

Hope this helps.

[bangerz253]

Thank you!

[Ashish_Mathur]

You are welcome.

[bangerz253]

@Ashish_Mathur  How do I share you a downloadable link? I'm new to Power BI , sorry!

[bangerz253]

@Ashish_Mathur https://app.powerbi.com/groups/me/reports/bc39f3b5-7e93-48a5-9260-3ab3c06fbad1?ctid=f6b6dd5b-f02f-44...

Thank you so much!

[bangerz253]

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!