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?
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.
Helper II 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: