title: Make first few rows unresponsive to slicer Power BI
body: <p>I have a data which looks like below:</p>
  <pre><code>  Brands  Sales Category Index
    Brand1    588        A     1
    Brand2    846        A     2
    Brand3    827        A     3
    Brand4    951        A     4
    Brand5    673        B     5
    Brand6    637        B     6
    Brand7    575        B     7
    Brand8    995        B     8
    Btand9    737        C     9
   Brand10    661        C    10
   Brand11    729        C    11
   Brand12    789        C    12
   Brand13    836        C    13
  </code></pre>
  <p><strong>Problem statement :</strong></p>
  <p>I am trying to put Category as a slicer. However I want the rows for Category A to be present in the table view irrespective of the slicer which is selected.</p>
  <p><strong>Example:</strong> Lets say if Category B is selected in slicer , in this case the table should return all rows until Rank 8.</p>
  <p>Below is an example of the desired output when category C is selected:</p>
  <p><a href="https://i.stack.imgur.com/02iCCm.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/02iCCm.png" alt="enter image description here" /></a></p>
  <p>As you can see, the visual table has both Category A and Category C.</p>
  <p>Similarly when both B and C are selected, I should be able to display all the categories (A,B and C).</p>
  <p>What  tried:
  I was thinking if we can use a conditional DAX which return 1 for selected values in slicers and mark rest as 0, I could use that as a visual filter and filter out 0. I tried various combinations of <code>Filter</code> with <code>in Filters</code> and <code>SELECTCOLUMN</code> but it did not work. Even the below measure returns all the rows instead of <code>Selected values|| category=&quot;A&quot;</code></p>
  <pre><code>test1 = CALCULATE(MIN('Table'[Index]),FILTER(ALLEXCEPT('Table','Table'[Brands]),'Table'[Category]=SELECTEDVALUE('Table'[Category]) || 'Table'[Category]=&quot;A&quot;))
  </code></pre>
  <p>I also tried something like:</p>
  <pre><code>test = var cat = min('Table'[Category]) return IF(cat = SELECTEDVALUE('Table'[Category])||cat=&quot;A&quot;,1,0)
  </code></pre>
  <p>But this gives all as 1 , doesnot give 0 for rows which does not match the condition (note I have blocked the slicer interaction here)</p>
  <p><a href="https://i.stack.imgur.com/rIQoPm.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rIQoPm.png" alt="enter image description here" /></a></p>
  <p>Any help would be highly appreciated.</p>