Need to know count of survey need to achieve the goal

[saud968]

I wanted to know the count of CSAT of value "5" to achieve the average score of 3.9. example Ricky needs 5 more surveys to achieve an average score of 3.9

I have tried this 

Needed Survey = IF([Average SAT]>=3.9, 3.9 - [Average SAT] * CSAT[C-SAT]= 5, COUNT(CSAT[CSAT] )) but i am getting result as true or false. Average SAT is another measure which i used Average(csat[csat]) 

How do i get the count

Case Number	Responded Date (America/Cancun)	Closed Date (America/Cancun)	CSAT	CES	Comments	PCM	Product	Inquiry/Problem/Request
154247	7/1/2021 1:30 AM	7/1/2021 1:29 AM	5	5		Saud Ansari	Fortify	Problem
121032	1/30/2021 4:08 AM	1/22/2021 5:33 PM	5	5		Salman Patel	Portal	Inquiry
121371	2/2/2021 4:04 PM	1/26/2021 4:01 PM	3	3	The feature is not available right now in the portal	Salman Khan	Security - Software	Problem
120790	1/31/2021 4:41 PM	1/31/2021 2:08 AM	4	4	While the Partner care team were very good at opening a line of communication, we still feel that the NOC are often letting us down.	Ronak Waghela	Portal	Problem
135328	4/30/2021 10:56 AM	4/28/2021 2:03 AM	5	5		Saud Ansari	HD Service	Inquiry
154803	6/30/2021 12:58 PM	6/30/2021 12:56 PM	5	5		Salman Khan	Control	Inquiry
162411	8/3/2021 11:09 AM	7/30/2021 8:16 PM	5	5		Ronak Waghela	Assist Help Desk	Problem
123590	2/18/2021 4:14 PM	2/10/2021 5:15 PM	1	1	I doubt there is anything connectwise can do to stop sucking. We really HATE that we have to deal with Connectwise as a Continuum	Salman Patel	Portal	Inquiry
134973	4/26/2021 4:03 PM	4/26/2021 1:51 PM	5	5		Salman Patel	Portal	Inquiry
156644	7/20/2021 4:22 PM	7/13/2021 3:54 PM	3	3		Ronak Waghela	Portal	Inquiry
136168	5/5/2021 9:51 AM	5/4/2021 4:57 PM	4	4	N/A - I was the last person to be assigned this. I'm sorry I cannot provide further feedback. I appreciate your support while looking into this case.	Salman Khan	Not Product Related	Problem
142958	6/7/2021 6:23 AM	6/5/2021 6:52 AM	5	5		Ricky Thakur	Fortify	Inquiry
138626	6/7/2021 5:46 AM	5/26/2021 3:00 PM	5	5		Ricky Thakur	Fortify	Problem
121842	2/7/2021 3:12 PM	1/29/2021 5:01 PM	2	2	please call us to validate if we are indeed aware of overdue account first. due to your upgrades and system changes, our auto pay setup was disregarded and we would normally check auto pay accounts.	Sagar More	Portal	Problem
155721	7/10/2021 7:26 AM	7/10/2021 6:06 AM	2	3	When agreeing a future action, some sort of date for when it will be done should be agreed.  In this instance it was especially important as the issue has been left unresolved for many months.  Some form of commitment is required or even conformation nothing will be done.	Rajeshkumar Patwa	Control	Problem
153632	6/28/2021 3:09 PM	6/26/2021 5:30 PM	5	4		Sagar More	Assist Help Desk	Problem
134538	5/11/2021 2:16 PM	5/11/2021 1:40 PM	4		Please have your team (NOC) read notes before pushing it back to the queue.	Salman Khan	RMM - Server Service	Problem
130570	5/4/2021 8:58 AM	4/6/2021 4:37 PM	1	1	everything, communication, actually resolve issues.	Ricky Thakur	Portal	Inquiry
117814	1/6/2021 10:41 AM	1/6/2021 9:36 AM	1	2	the issue is still not resolved.  It has now been 5-6 times you have tried to fix it.  It is frustrating that you can't seem to evaluate whether the resolution has worked.	Ricky Thakur	RMM - Desktops	Problem

[AllisonKennedy]

@saud968 

This is an algebra question more than anything. Not sure if I am using the same logic you want, but here's my DAX:

Count 5 surveys needed to reach 3.9 avg =

IF([AvgCSAT]<3.9,

ROUNDUP(DIVIDE([SumCSAT]-3.9*[CountCSAT],3.9-5),0))

Thanks also to @ChrisMendoza , I have modified your report. See attached below signature. 

[saud968]

@AllisonKennedy    This is what i am getting after coming changes to 

Needed Survey = CALCULATE(CSAT[Average SAT],FILTER(CSAT,IF([Average SAT]<=3.9, 3.9 - [Average SAT] * COUNT(CSAT[CSAT]), COUNT(CSAT[CSAT]))))

However, it is incorrect as Ronak needs 22 more surveys with the perfect score of "5" to reach 3.9. Below is the current list of surveys and scores for Ronak. in excel we have used this formula - =IF((H3=""),"",IF(H3>=3.95,0,(3.95-H3)*COUNTIF('Raw Dump'!B:B,'PCM Summary'!B3)))

4
5
3
1
5
2
4
1
5
1
1
2
5
5
1
2
3
1
5
1
1
2
5
5
4
4
1
4
1
5
5
5
5
5
5
5
5
5
1
5
3
1
5
1
5
4
1
5
1
1
5
5
5
5
4
5
4
5
2
4
1
5
5
5
5
1
5

[AllisonKennedy · Accepted solution]

@saud968  You need to include the SUM of all survey results which you have removed from my measure. Please refer to the attached file in the previous post, but here are all measures for reference (I think Chris may have created some of them for you).

All as MEASURES:

SumCSAT = SUM(CSAT[CSAT])

AvgCSAT = AVERAGE(CSAT[CSAT])

CountCSAT = COUNT(CSAT[CSAT])

Count 5 surveys needed to reach 3.9 avg =

IF([AvgCSAT]<3.9,

ROUNDUP(DIVIDE([SumCSAT]-3.9*[CountCSAT],3.9-5),0))

[saud968]

 @AllisonKennedy  @ChrisMendoza @amitchandak    please help

[ChrisMendoza]

@saud968 -

Are you saying for [PCM] = 'Ricky Thakur':

Count of CSAT = 4

Sum of CSAT = 12

Average of CSAT = 3

The question being...

How many surveys (new entries) does [PCM] = 'Ricky Thakur' need with a [CSAT] = 5 (best score) to meet the Total Average of the data?

I honestly do not think I would know how to solve that. For each new count, presumably others are entering as well, affects the Total Average. In any case, I've created a PBIX file so others may start to tackle it.