title: Complex Filter in Power BI
body: <p>I have a table called Service Agreements . There is a calculated column that depending on the record status will have a value returned for each row , Old Record or Active Record, not both .</p>
  <p>So I have a Filter on a Power BI Page, called Include Agreement History , that has values of Active Record and Non Active with a Select All option . However the want now is to have 2 values for this FILTER , Yes and No.</p>
  <p>With the calculated column in the Service Agreements,  each row currently gets a single value like Old Record or Active Record. The yes category change would means rows with old record and Active records . For the No option, the rows would be only the old records .  Is there a way of getting the values for this filter to change to Yes and No ? In Power BI there does not seem to be this grouping available that can be used in Filters this way.</p>