Trying to populate a column with data from another table, using a filter

[Parkyerbike]

Hi, I am new to Power BI and I am trying to create a column in a table with a customer name that is held in another table, but only where the environment is set to production

Example trying to populate the Customer Name in this DIM table. This table only has Unique values, the key is ID

From Data in this FACT table, but only where the environment is production, the column called CustomerDescr exists in the below table also, which is what I am trying to get in the above, this table has 500+ rows, and 300+ distinct values, the Key is IdentifiedInstallationID

I have relationships set up between the 2 tables (1 to Many)

Thanks in advance

Dave

[Parkyerbike]

@hackcrr Thanks, worked great

[hackcrr · Accepted solution]

Hi, @Parkyerbike 

You might want to try the following DAX expression:

Customer Name =
CALCULATE (
    MAX ( 'Table2'[CustomerDescr] ),
    FILTER (
        'Table2',
        'Table'[Id] = 'Table2'[IdentifiedInstallationID]
            && 'Table2'[Enviroment] = "Production"
    )
)

Below is the example data I used:

table1:

table2:

relationship:

The results of the calculation columns are shown below: