Forum Discussion
Helper IUnable to do table with 3 or more sources
What relationships, exactly, are established? Between which columns in which tables? What are their crossfiltering directions? Cardinality? How are you trying to display these? A matrix? If so have you put anything in the Values box?
Helper IThank you for the reply. I have established relationships of all tables to the RootID. (The common denominator of all the tables).
Playing around with the crossfiltering did not make a difference. I am attempting to display these fields in a Matrixed table.
I also do not understand what cardinality is.
Upon your suggestion I did move some of the fields to the Values box and that DID have a positive result. Could you possibly please explain the difference between Values and Column/Rows?
Cardinality is many to one, one to many, one to one, etc.
Playing around with crossfiltering would only make a difference if you had something in Values and things still were not working correctly.
The matrix visual is specifically meant to show values for different combinations of rows and columns. Whatever you put in Values will be aggregated according to the intersections of those rows and columns. Measures often take advantage of the USERELATIONSHIP or CROSSFILTER formulas to manipulate how those relationships between tables work, and even if not there may be multiple relationships in play, so some kind of Value contents are needed to make the matrix function.
- TM_Evan
I noticed that Power BI (so far) does a good job in selecting the cardinality correctly then.
As for Matrix vs Table, I totally see that now. I really appreciate your help as well as others in the community.
Yeah unless you're deliberately doing something weird it's pretty good at auto-selecting the right cardinality. But I never know if the person asking the question has done something weird. :smileywink: