How to rename Blank row header in Matrix table?

Question

I have a reference table that lists team names and locations and another table that lists the amount for each team. There may be teams that are missing in the reference table. For these, I want to show them as "Not Defined" in the matrix table. How can I do that? Right now they are grouped in without any name. Please see the screenshot below. Team C is missing in the reference table. So I want to show the aggregate of missing teams as 'Not defined' in the matrix table instead of Blank under the Team column.

mahoneypat · Accepted Answer

One way to do it is to make another table with a DAX expression like the one shown below.&nbsp; You can then relate that new table to your Amounts table on the Team column to get your desired table visual.
&nbsp;

NewTable&nbsp;=ADDCOLUMNS&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;DISTINCT&nbsp;(&nbsp;Amounts[Team]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;"InTeamsTable",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;IF&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ISBLANK&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE&nbsp;(&nbsp;MIN&nbsp;(&nbsp;Teams[Team]&nbsp;),&nbsp;TREATAS&nbsp;(&nbsp;{&nbsp;Amounts[Team]&nbsp;},&nbsp;Teams[Team]&nbsp;)&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"Not&nbsp;Defined",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Amounts[Team]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;))
&nbsp;

&nbsp;
Pat
&nbsp;
&nbsp;
&nbsp;

Forum Discussion

How to rename Blank row header in Matrix table?

1 Reply

Related content

Rename Date Column Header

Dynamic Column Header In a Matrix

Matrix Header Heigth Problem only online

Rename blank header in a matrix

Renaming multiple Headers