Forum Discussion
Helper IIICreating Table Visual with multiple tables
Hi Ray_Brosius ,
In your scenario, you can create your relationships like below.
But, also need to create a measure like yours.
It should be noted that "both" direction has a significant drawback about performance. You can find details here. And, sometimes, it may cause an ambiguous model. You can find details here.
So, I use "CROSSFILTER" function.
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
Community SupportHi Ray_Brosius ,
Normally, this is caused by returning multiple different results for the same category. Please check.
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
Ray_BrosiusHello Icey ,
I'm not quite sure what you mean by "returning multiple different results for the same category". In my data I have JIRA Issues that where an Issue can be tied to one or more Customers, one or more Components, and one or more Versions. What I am trying to do is build a report that shows a list of Defects(Jira Issues) in a table and include in that table columns showing the Customers, Components and Versions for each Jira Issue. I guess in thinking more about this the Table is confused because for a single Jira ISSUE, it does not know how to show the "list" of each potential category value? I assumed it would just give me multiple rows per issue... I also tried a Matrix/Pivot table to see the same.. but the Matrix table has the same behavior...
For a scenario like this where we have an Entity that has multiple attributes, that each can contain multiple values per Item. How do we model this properly? Maybe I need to have on teh fact table a "column" per attribute that is a comma seperated list and use this for "display" purposes, but use the tables that I created for showing each value in each category per issue in single rows, for analysis.