title: DAX Query Tabular: How to use SUMMARIZE Function with FILTER Function, which have different columns on both functions
body: <p>We are Using <strong>SELECTCOLUMNS</strong> Function for providing Alais Name, <strong>SUMMARIZE</strong> function for Aggregating the Data, also we are using <strong>FILTER</strong> function to filter data in the same query.</p>
  <blockquote>
  <p><strong>Requirement</strong> : We want to perform Aggregation on Some other Columns and
  want to perform Filter on another column in a same query. As we can do
  in SQL, Can we do in DAX also, if yes then can you post an example?</p>
  </blockquote>
  <p><strong>SQL Example:</strong></p>
  <p><code>select Column1 from TableName where Column2 = 'PO Flag' group by Column1</code>.</p>
  <p><strong>DAX Example:</strong></p>
  <pre><code>Evaluate (    SelectColumns(     Filter (      Summarize ( 
       'Internet Sales', 
       'Product'[Model Name], 
       &quot;Sales&quot;,SUM('Internet Sales'[Sales Amount])
       ) ,  
       'Product'[Product Name]=&quot;HL Road Tire&quot;
       )  ,    &quot;Product&quot;,'Product'[Model Name],    &quot;Sales&quot;,[Sales]   )   )
  </code></pre>
  <p>Please help !!!!</p>