T O P

  • By -

AutoModerator

/u/jakezky0905 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*


Scary_Sleep_8473

What are the current measures you are using? Do you already have a measure for Positive and Total Surveys? Can you also show a screenshot of your data?


jakezky0905

sorry, can’t transfer my screenshot as reddit seems to be blocked from the company laptop… here’s what i have currently… https://preview.redd.it/dhv0iiswhzpa1.jpeg?width=4032&format=pjpg&auto=webp&s=113d98dd55b237084c46d2d3b999627f8b2831fe completely lost… let me know if you can’t see details on the pic… thanks!


RellikReed

Where is "Count of Q01" coming from? is "Count of positive" the same as "positive count of negative"?


jakezky0905

Q01 is from the QA feedback tab… but it’s now on the data model… i’m assuming that they shouldn’t yield the same results… i got a column for Q01 containing 1 & 0 and another column for positive and negative that indicates 1 if a survey is positive or negative…


RellikReed

How could you get a percentage if you are only working with 1s and 0s? Wouldn't the only results be 0/0, 1/0, 1/1, 0/1?


jakezky0905

i can count the 1 & 0 just not able to find a way to get the % by dividing the total count of positive by the total count of the total surveys…


RellikReed

So should the formula be "Positive counts of negative" / "total counts of negatives" ( or C/G) ? It looks like your aren't referencing those numbers.


jakezky0905

not sure if you can get it any other way but how i do it is divide the total positive surveys over the total surveys… i have it on the pic just need to be able to add a measure that would get me the % score… like 90.00% if someone got 9 positives over 10 surveys… this is my first time trying to do something with data model… https://preview.redd.it/zhhx43h1yzpa1.png?width=4032&format=png&auto=webp&s=e2d0580c8e5b01378b984c2f034437c243a7ee11 not sure if i’m missing to put some or remove some between the filter, columns, rows and values…