Forum Discussion

Ray_Brosius's avatar
Ray_Brosius
Helper III
5 years ago
Solved

Creating Table Visual with multiple tables

I am trying to create a simple simple table that has some of the Attributes from the CC Defects table and then the corresponding tables which hold one or more records per defect.   When I create the ...
Need Help
  • Icey's avatar
    Icey
    5 years ago

    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.

Ray_Brosius's avatar
Ray_Brosius
Helper III
5 years ago

Icey 

Thanks for the very detailed explanation.  I will test out the crossfilter...  Curiuos as to when you say sometimes the "BOTH" direction relationship fails..?  How is that and what does that mean?  I'd like to better understand this.  

Icey's avatar
Icey
Community Support
5 years ago

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.