title: I need to filter my table in Power BI with multi filter with "AND" logic
body: <p>I'm new to Power BI and DAX Language.</p>
  <p>I have a table that contains names, skills, and assessments. For example, like this:</p>
  <p><img src="https://i.stack.imgur.com/W7mf5.png" alt="enter image description here" /></p>
  <p>In Power BI, I need to have two filters one by skill and other by assessment, to show me the name that I want:</p>
  <p>For example: If I filter by skill =Python and assessment between 2 and 3, the result should be Name =A, not A, and C, what happened is output is considered that I have at least one result, that is Python.</p>
  <p>Conclusion: I want to filter by skill (or all skills) AND by level (which can be ONE level or an interval). For default Power BI shows me OR not AND.</p>
  <p>I try this DAX formula:</p>
  <pre><code>name with all skills = 
  CALCULATE (
  COUNTROWS (
      FILTER (
          ADDCOLUMNS (
              VALUES ( Assessments[corp id] );
              &quot;Skills&quot;; CALCULATE (
                  COUNTROWS ( VALUES ( Assessments[skill] ) );
                  CALCULATETABLE ( Example )
              )
          );
          [Skills] = COUNTROWS ( ALLSELECTED( Assessments[skill] ) )
      )
  );
  ALLSELECTED (Assessments[skill] )
  )
  </code></pre>