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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.