How to rename Blank row header in Matrix table?

[RJS849]

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 solution]

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

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

Pat