title: Sumif equivalent for Power Pivot Measure Calculations
body: <p>this is my first question here and i will try my best to ask my question in a good way.</p>
  
  <p>I am very experienced in using Excel, but quiet new to the Power Tools. I have a Data Model set up in the following way</p>
  
  <p>Table SalesData:</p>
  
  <pre><code>Day | Amount Ordered | Amount Sent | toBeAchived (Service Level per Month)* 
  1          10              10                     87,5%
  2          20              15                     87,5%
  3          15              15                     87,5%
  ..
  51         20              18                     90,0%
  </code></pre>
  
  <p>Table Calender:</p>
  
  <pre><code>Day | Month
  1       1
  2       1
  3       1
  ..      
  51      2
  </code></pre>
  
  <p>I then created a measure:
  Service Level:= sum(Amount Ordered) / sum ( Amount Sent)</p>
  
  <p>If I now create a pivot table I can aggregate the month and see the service level of for example month 1.</p>
  
  <p>Now I want to build a graph, with days on the x-Axis, but with the Mothly Average Service Level, but since its disaggregated I get the measure daily.</p>
  
  <p>so what I need is a sumif(Amount ordered, Month = @Month) which would be easy in an Excel Table.</p>
  
  <p>*I tried the Calculate function like this as a CalculatedColumn:
  calculate(sum('Sales Table'[Amount Ordered]), Calender[Month]=Calender[Month])</p>
  
  <p>which of course does not work. So the question is, how can I set the filter in the CALCULATE function to the @Month Value for each row?</p>
  
  <p>Thanks for your help in advance</p>