Forum Discussion

Parkyerbike's avatar
Parkyerbike
New Member
2 years ago
Solved

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

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

Need Help
  • hackcrr's avatar
    hackcrr
    2 years ago

    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:

     

2 Replies

  • hackcrr's avatar
    hackcrr
    Memorable Member
    2 years ago

    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: