Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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:
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:
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
92 | |
82 | |
63 | |
62 | |
58 |
User | Count |
---|---|
159 | |
115 | |
103 | |
75 | |
66 |