Count the number of elements that meet a certain summed criteria

[matt-b]

I am looking to track the number of submissions by certain users. The measure I am struggling to calculate is the percentage of users that have hit the target number of submissions (5) in a certain date range (1 week).

Each submission is a row in the data source. In a matrix I can display each users completion %, but I am unable to create a measure that tells me what % of these users are at 100% completion.

[Anonymous]

Hi @matt-b ,

I think your issue is based on your data model. Please share a sample file with us and show us a screenshot with the result you want. This will make it easier for us to find the solution.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[matt-b]

I am not sure how to provide a sample file so I am hoping to explain this as best I can. Below is an example of the data set. Users are filling out a form to populate this. The requirement is to fill out this form 3 times in a week. Below, 8 total forms were filled out. I have a separate data source that has a list of all the people to fill out the form (5 unique persons). The total target of forms to fill out is 15 (5 people x 3 forms). Based off of this, total form completion % is 53% (8/15). I would like to calculate the number of people who have met the criteria of 3 forms (Bob and Susie). This would be 40% (2/5).

Name	Date	Answer 1	Answer 2	Answer 3
Bob	10/6/2023	Yes	No	No
Susie	10/4/2023	Yes	Yes	Yes
Bob	10/3/2023	Yes	Yes	No
Andrew	10/3/2023	Yes	No	Yes
Susie	10/3/2023	Yes	No	No
Susie	10/2/2023	No	Yes	Yes
Bob	10/2/2023	No	No	Yes
Rachel	10/1/2023	Yes	Yes	Yes