Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
bangerz253
Frequent Visitor

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

power bi.PNG

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!

1 ACCEPTED SOLUTION

Hi,

Download the PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

16 REPLIES 16
Anonymous
Not applicable

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

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

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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

Hi,

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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

Hi,

That is not a downloadable PBI file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hi,

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hi,

Download the PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Thank you!

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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

 

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!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.