title: How do I filter results by a measure in Power BI
body: <p>I need to be able to filter by a measure to show more granular results in Power BI. I would like to be able to choose where the percentage is in a range, or  = 100%</p>
  
  <p>My calculation for the measure is this (each column can only be 1 or 0):</p>
  
  <pre><code>errorPercentage = CALCULATE(SUM([missing data])/SUM([expected]))
  </code></pre>
  
  <p>This works fine in the table and correctly shows the percentage which can be cut in many different ways.</p>
  
  <p>However, when adding a filter element/visual, Power BI wont let me use the errorPercentage measure.</p>
  
  <p>What is more confusing is that if I go to the Visual Level Filters section on the table I want to filter, I CAN use the errorPercentage measure to filter in a range or value.</p>
  
  <p>Can anyone suggest an easy to use filter? I'm trying to let the users of the report choose a % range themselves, rather than having a pre-defined one.</p>