From the course: Power BI Weekly

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Creating a symmetrical matrix

Creating a symmetrical matrix - Power BI Tutorial

From the course: Power BI Weekly

Start my 1-month free trial Buy for my team

Creating a symmetrical matrix

“

- [Instructor] An interesting twist on a matrix visual lets those visualize calculations symmetrically between different pairs of categories. Examples of these calculations include math operations, correlations, or distances between two points. Let's start with a simple example where we have a matrix visual with the category in the columns and the data total measure, which measures the sum of the values in the values for the matrix. This gives us a total for each category as determined by the row labels. Let's say that we want to get the totals for A + A, A + B, and so on through all the possible combinations of pairs. We can't do this in our matrix using the filter context when we add the same category field to the columns. When we add an identical category label from the exact same table that's duplicated in the model, we see it returns the same result for each of the rows. Instead, we want to create a Cartesian product for all the paired combinations of categories. Let's instead…

Contents