Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.

Get started- Power BI forums
- Updates
- News & Announcements
- Get Help with Power BI
- Desktop
- Service
- Report Server
- Power Query
- Mobile Apps
- Developer
- DAX Commands and Tips
- Custom Visuals Development Discussion
- Health and Life Sciences
- Power BI Spanish forums
- Translated Spanish Desktop
- Power Platform Integration - Better Together!
- Power Platform Integrations (Read-only)
- Power Platform and Dynamics 365 Integrations (Read-only)
- Training and Consulting
- Instructor Led Training
- Dashboard in a Day for Women, by Women
- Galleries
- Community Connections & How-To Videos
- COVID-19 Data Stories Gallery
- Themes Gallery
- Data Stories Gallery
- R Script Showcase
- Webinars and Video Gallery
- Quick Measures Gallery
- 2021 MSBizAppsSummit Gallery
- 2020 MSBizAppsSummit Gallery
- 2019 MSBizAppsSummit Gallery
- Events
- Ideas
- Custom Visuals Ideas
- Issues
- Issues
- Events
- Upcoming Events
- Community Blog
- Power BI Community Blog
- Custom Visuals Community Blog
- Community Support
- Community Accounts & Registration
- Using the Community
- Community Feedback

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

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

- Power BI forums
- Forums
- Get Help with Power BI
- DAX Commands and Tips
- Calculate number needed to obtain Percentage goal

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Calculate number needed to obtain Percentage goal

03-17-2021
10:00 AM

First off if this is a double post I'm sorry, I submitted it earlier and it looks like it didn't go through...

This might be more of a mathmatics question, but I figured I'd ask here.

I'm working on a dashboard that summarizes survey results... you know the ones you take when you get your car serviced and the beg you to give them nothing but 10's. In this case it's basically a thumbs up or thumbs down, which should be easier.

I need to calculate how many thumbs up it would take to get them to 98%. Basically I have the following calculated:

Current Score = 94.5%

Target Score = 98%

Percent to Target = 3.5%

And I need:

Number of thumbs up needed to reach target = ????

The denominator is simply the number of surveys returned. The numerator is number of surveys returned minus thumbs down.

Essentially what my issue is say you have 50 surveys and a score of 50%, so each survey is 2% of the total. Your goal is 75%... at first look it would seem you would need 13, but when you add these new surveys in each one now accounts for 1.5873%, meaning 13 would get you to just 68%... how do I account for that?

Solved! Go to Solution.

1 ACCEPTED SOLUTION

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

03-18-2021
02:08 PM

@ABR002 you're right, this requires a bit of algebra.

Let's define the following variables, with your sample values in bracketrs:

*r*= number of survey responses so far (50)*p*= number of positive survey responses so far (25)*T*= target positive proportion as a decimal (0.75 = 75%)*k*= additional positive responses required to get to target (assuming only positive received from now on)

Then we need to solve this equation for *T*:

A little algebra gets you to the solution:

Using your example, if you had 25 positive responses out of 50, to get to a positive proportion of 0.75 would require:

k = ( 0.75 * 50 - 25 ) / ( 1 - 0.75) = 50

So 50 more positive responses would be required.

You can write this as a measure something like this, assuming you have measures for all the input variables:

```
Additional Positive Responses Required =
VAR Target = 0.75
VAR Positive = [Positive Responses]
VAR Total = [Total Responses]
VAR AdditionalPositiveRequired = ( Target * Total - Positive ) / ( 1 - Target )
RETURN
AdditionalPositiveRequired
```

Regards,

Owen

4 REPLIES 4

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

03-26-2023
12:34 AM

This worked great! Thank you! however, is there a chance to only show the aggregated positive values only?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

03-18-2021
02:57 PM

Thank you so much. Obviously I'm not a math major, so I may have done something a bit wrong. But when I used your example as a solution, it gave me the total number of responses I would need to be at (as in the lowest number of total responses it would be possible to reach the goal,) not the additional number it would need. Luckily I had manually figured the out the number it would need to be at yesterday so I immediatley recoginized the number, and simply subtracted the current positive count from your example and that got the number I was after. Either way thanks, I couldn't have done this without you.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

03-18-2021
02:08 PM

@ABR002 you're right, this requires a bit of algebra.

Let's define the following variables, with your sample values in bracketrs:

*r*= number of survey responses so far (50)*p*= number of positive survey responses so far (25)*T*= target positive proportion as a decimal (0.75 = 75%)*k*= additional positive responses required to get to target (assuming only positive received from now on)

Then we need to solve this equation for *T*:

A little algebra gets you to the solution:

Using your example, if you had 25 positive responses out of 50, to get to a positive proportion of 0.75 would require:

k = ( 0.75 * 50 - 25 ) / ( 1 - 0.75) = 50

So 50 more positive responses would be required.

You can write this as a measure something like this, assuming you have measures for all the input variables:

```
Additional Positive Responses Required =
VAR Target = 0.75
VAR Positive = [Positive Responses]
VAR Total = [Total Responses]
VAR AdditionalPositiveRequired = ( Target * Total - Positive ) / ( 1 - Target )
RETURN
AdditionalPositiveRequired
```

Regards,

Owen

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

04-19-2024
07:01 AM

Would there be a way, or a formula used, to input something like this into an Excel Spreadsheet, where I could make mulptiple Spreadsheets for each Metric I am looking to track, and calculate, the number of survey responses needed?

Not looking to have all on one sheet, but multiple sheets containing one metric each. I am looking to create a presentation to explain the impact one negative survey can have and the importance of customer service (Like the gentlemen above, I am in the automotive industry and these surveys are vital)

Top Solution Authors

User | Count |
---|---|

51 | |

37 | |

20 | |

14 | |

13 |

Top Kudoed Authors

User | Count |
---|---|

96 | |

71 | |

29 | |

20 | |

13 |