Forum Discussion

Ray_Brosius's avatar
Ray_Brosius
Icon for Helper III rankHelper 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
Icon for Helper III rankHelper III
5 years ago

Icey In your "Customers 2" measure.. why do you have multiple crossfilters in the calculate function?

 

Ahhh wait, editing this reply..

I see that the two crossfilters go to the "other" two tables containing multiple attributes per defect.  So for each Measuer you need to cross filter against all the other tables that contain the list of attribute values per defect... 

 

I did not read the formula close enough on quick scan