Forum Discussion
Table view collapsing due to relationships issue.
I have the below model view in my Power Bi report.
the quiz summary has the unique quiz id's and has a many to one relationship with quiz activity, quiz attempts and eligible users.
The eligibleusers table has a many to one relationships with the custom userdetails table (userid column)
When I create a table view in desktop, containing the columns from quiz activity alone and add username column from the customuserdetails table, the view collapses (quiz activity has an username column as well). However when I take all the columns from quiz summary and add username from custom user details table, then the view is not collapsing.
I am not able to build a relationship between customuserdetails table and quiz activity table as it saying it is ambiguous.
Can anyone let me know why this is happening?, all relationships are bi-directional only and there are no many to many relationships.
- Anonymous2 years ago
Hi Ishaq ,
Regarding your question, do you encounter this error?
In a table visual, one cell corresponds to one data. This error will occur when one cell corresponds to multiple data. You just need to merge the multiple data into one data.
Something like this.
Measure = CONCATENATEX('Table2',[ID],UNICHAR(10))CONCATENATEX function (DAX) - DAX | Microsoft Learn
Best Regards,
Wenbin Zhou
1 Reply
- AnonymousNot applicable
Hi Ishaq ,
Regarding your question, do you encounter this error?
In a table visual, one cell corresponds to one data. This error will occur when one cell corresponds to multiple data. You just need to merge the multiple data into one data.
Something like this.
Measure = CONCATENATEX('Table2',[ID],UNICHAR(10))CONCATENATEX function (DAX) - DAX | Microsoft Learn
Best Regards,
Wenbin Zhou