Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am having dataset created. here i need to create new relationship between two tables. Inbetween these two tables there is a common column but i cannot create realtionship make the relation ship active. Getting cardiinality issues asking to remove other relationships to active this relationship. but i required those relations ships as well. What is need to do here.
Solved! Go to Solution.
In Power BI, a table can't have multiple active relationships to the same table. Workarounds for this is to duplicate that table or use DAX function USERELATIONSHIP()
Details in this article: https://www.sqlbi.com/articles/using-userelationship-in-dax/
@Anonymous
In case do not want to use dax to include inactive relationship, you could create a bridge table with Distinct or Summarize depends on your requirement.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
You need to create a new dimension table with unique values convering the range of values for the common field in both tables. You then create a one-to-mamny relationship between the field in the new dimension table and the corresponding fields in each fact table. Use the dimension field in measures, filters, slicers and visuals.
Proud to be a Super User!
Paul on Linkedin.
In Power BI, a table can't have multiple active relationships to the same table. Workarounds for this is to duplicate that table or use DAX function USERELATIONSHIP()
Details in this article: https://www.sqlbi.com/articles/using-userelationship-in-dax/
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |