I'm looking for ideas on best way to select a set sample sizes for different categories/groups. I have a source table pulling in raw data, and a population table that scrubs preps the data (removes duplicates, randomly selected, etc.). There are several categories of records for the current month and each will have it's own sample size. We have a required sample size for each of the categories and sometimes a category will not have the needed number of records to meet the required. I'm using slicers to select each category and records, which can take some time to get the needed sample.
I've researched using a join with a manual table with the required sample sizes for each category, but not having much luck if that's a good approach. I have tried pulling the samples using SQL with hard coded sample sizes, but that turned out to take a lot of time to adjust for missing records to meet needed minimum. My end goal is to create a self serve dashboard so end users can select the records themselves and export as they need. Any thoughts or advice on other approaches i haven't found so far?
