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.
I have created a table which has a field of the type Text. I'm trying to join on another field in a table that is also of the type text but that field was created as a measure. When try to create a relationship between the 2 Power BI doesn't "see" the field to create the relationship.
Why?
Solved! Go to Solution.
@Del235 Hello,@ExcelMonke ,thank you for your help of this issue.Your answer is excellent!
And I would like to share some additional solutions below.
I am glad to help you.
According to your description, you want to use measure to establish relationships with fields in other tables.
Unfortunately, this is not possible. Here are the results of my tests:
I tried to make the Resource Name in the Booking table related to the newly created measure M_, but it failed.
Here is the reason I analyzed, you can refer to it:
The relational model in power BI does not support a field in a table to establish a relationship directly with a newly created measure.
The reasons is as follows:
The relationship model between data in power bi is built before the data is loaded, while the measure is calculated after the data is loaded, it depends on the current computing environment. Simply put, measure must have specific data in order to work properly, while the relationship is not dependent on specific data.
If you want to achieve a similar effect, you can create a calculate column with the same functionality as the current measure to replace it. calculate column is similar to a normal column, you can use calculate column to establish relationships with other table fields.
Test Data:
M_ =
SELECTEDVALUE('Resources'[Resource Name])
C_ = 'Resources'[Resource Name]
Create a relationship with the "Resource Name" of another Booking table by calculating column C_ instead of M_.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Del235 Hello,@ExcelMonke ,thank you for your help of this issue.Your answer is excellent!
And I would like to share some additional solutions below.
I am glad to help you.
According to your description, you want to use measure to establish relationships with fields in other tables.
Unfortunately, this is not possible. Here are the results of my tests:
I tried to make the Resource Name in the Booking table related to the newly created measure M_, but it failed.
Here is the reason I analyzed, you can refer to it:
The relational model in power BI does not support a field in a table to establish a relationship directly with a newly created measure.
The reasons is as follows:
The relationship model between data in power bi is built before the data is loaded, while the measure is calculated after the data is loaded, it depends on the current computing environment. Simply put, measure must have specific data in order to work properly, while the relationship is not dependent on specific data.
If you want to achieve a similar effect, you can create a calculate column with the same functionality as the current measure to replace it. calculate column is similar to a normal column, you can use calculate column to establish relationships with other table fields.
Test Data:
M_ =
SELECTEDVALUE('Resources'[Resource Name])
C_ = 'Resources'[Resource Name]
Create a relationship with the "Resource Name" of another Booking table by calculating column C_ instead of M_.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You are not able to create a relationship using measures. A good way to think about it is, if the measure value changes, it will cause a Power BI to continuously change the relationship, and this may cause errors if the measure value is not as intended
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
188 | |
111 | |
105 | |
78 | |
71 |