Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All
When i add SEGMENT table to my PBI file , when i try to link segment field , i get :-
The linkage have multiple relationship.
My PBI file :-
Paul Yeo
Solved! Go to Solution.
Hi @Paulyeo11 ,
Good day,
In order to avoid the manay-to-many relationship, you need to do the following steps
1. Extract unique values from 1 table - Treat this as a Master Table (Dimension table)
2. Add relationship with the table to fact table
3. Now you can use 1-Many relationship
Thanks & Regards,
Mohammed Adnan
Hi @Paulyeo11 ,
Good day,
In order to avoid the manay-to-many relationship, you need to do the following steps
1. Extract unique values from 1 table - Treat this as a Master Table (Dimension table)
2. Add relationship with the table to fact table
3. Now you can use 1-Many relationship
Thanks & Regards,
Mohammed Adnan
Hi All
Thank you for sharing , but my issue is :-
You have to make it unique in one of the tables, and there can be no blanks or nulls in that field. Your segment_c field has a ton of blanks. You would have to:
It can then be the 1 of a 1:Many relationship.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingUser | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |