title: How do I use aggregation as filter in this dax measure?
body: <p>I have a table in PowerPivot with 4 columns: YearMonth, Location, PersonID, EndDate. I want to calculate turnover rate (employees that left/tot number of employees) and I have found the correct calculation, but I want to exclude all the locations that have less than say 100 Employees. I want this to be defined in the measure so I can use slicers both on Location and YearMonth.</p>
  
  <p>Here are my measures so far: </p>
  
  <p>TotEmployees:=DISTINCTCOUNT([PersonID])</p>
  
  <p>Leaving:=(CALCULATE(SUMMARIZE(TABLE1;[PersonID];[EndDate]));Table1[EndDate]]>0)</p>
  
  <p>Turnover:=Table1[Leaving]/Table1[TotEmployees]</p>
  
  <p>What do I need to add to my measures to filter the table to exclude all locations with less than 100 employees?</p>
  
  <p>Thanks in advance! </p>