Can I perform advanced data analysis with Power BI using SUMMARIZE and FILTER?

---

You can use the following syntax in DAX to use the SUMMARIZE function with the FILTER function:

Summary Table = FILTER(
        SUMMARIZE(my_data, my_data[Team], my_data[Points], my_data[Position]),
        my_data[Team] = "A")

This particular formula creates a new table named Summary Table that contains the Team, Points and Position values from the table named my_data, filtered on the rows where the value in the Team column is equal to A.

The following example shows how to use this syntax in practice.

Example: How to Use SUMMARIZE with FILTER in Power BI

Suppose we have the following table named my_data that contains information about various basketball players:

Suppose that we would like to use the SUMMARIZE and FILTER functions to create a new table that displays the values from the Team, Position and Points columns only for the players on Team A.

To do so, click the Table tools tab, then click the New table icon:

Then type the following formula into the formula bar:

Summary Table = FILTER(
        SUMMARIZE(my_data, my_data[Team], my_data[Points], my_data[Position]),
        my_data[Team] = "A")

A new table named Summary Table will be created that contains the values from the three columns in the original table, filtered for the rows where the Team column is equal to A:

Note that you can also filter on multiple conditions if you’d like.

For example, you could use the following syntax to filter the original table for rows where the Team column is equal to A and the Points column is greater than 20:

Summary Table = FILTER(
        SUMMARIZE(my_data, my_data[Team], my_data[Points], my_data[Position]),
        my_data[Team] = "A" && my_data[Points] > 20)