Forum Discussion
How do I pull information about linked issues while also displaying the field data for the dependent
Hi John_Sellars ,
Using a matrix in Power BI is like using a pivot table in Excel. Anything you put in values tile is aggregated (min, max, earliest, latest, first, last, sum, count,etc) so if you put a dimension in it, it will be summarized one way or another - and will show the crosssection of the dimensions added to the row and column tiles - eg, the sum of values which month is February and category is "ABC" or the of the first or last salesperson name (in alphabetical order) for the same crosssection.
Now, going back to your matrix, the results are repeating? Is that how it is supposed to be or does the table of the field in the values tile have a relationship to the fields in the row and column tiles? If they are from the same table, relationship shouldn't matter.