What% of Months hit the Target

[Sharma0815]

Hi All,

I am trying to create a measure to calculate what % of months that TOP2 surveys hit my target.

Here is my Dataset.

Dept	SurveyID	Survey	MM-YY
Marketing	23412	TOP2	Nov-20
Marketing	23413	TOP2	Nov-20
Marketing	23414	TOP2	Nov-20
Marketing	23415	TOP2	Nov-20
Marketing	23416	TOP2	Nov-20
Marketing	23417	TOP2	20-Dec
Marketing	23418	TOP2	20-Dec
Marketing	23419	TOP2	20-Dec
Marketing	23420	Bottom3	20-Dec
Marketing	23421	Bottom3	20-Dec
Marketing	23422	Bottom3	20-Dec
Marketing	23423	Bottom3	20-Dec
Marketing	23424	Bottom3	20-Dec
Marketing	23425	Bottom3	20-Dec
Marketing	23426	Bottom3	20-Dec
Marketing	23427	TOP2	Jan-21
Marketing	23428	TOP2	Jan-21
Marketing	23429	TOP2	Jan-21
Marketing	23430	TOP2	Jan-21
Marketing	23431	TOP2	Jan-21
Marketing	23432	TOP2	Jan-21
Marketing	23433	Bottom3	Jan-21
Marketing	23434	Bottom3	Jan-21

I got 100% TOP2 surveys in Nov-2020,30% in Dec-2020 and 75% in Jan-2021

I have one more table which contains the actual target by each department.

Dept	Target
Marketing	70
Sales	60
IT	55
Tech	80

So here,my marketing dept hit the target in Nov-2020 and Jan-2021,I need to calculate What % of months that actually hit the target.
here i should get 2/3 = 65%

[lbendlin]

Sounds pretty straightforward. What have you tried so far and where are you stuck?