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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Ray_Brosius - Can you share your .pbix file? (using Dropbox or google drive?)

 

Cheers,

-Namish B

  • Ray_Brosius's avatar
    Ray_Brosius
    Helper III
    5 years ago

    I cannot share this pbix file... customer identifying data in the dataset

    but to explain the "data"

    there are defects that have one or more records in teh three outside tables

    This is JIRA data where the fields are mutli-select fields.  so they are broken out to handle the multiple values.

    I am simply creating a table with the Defect Number, Created Date then try to add the Customer and one of the Versions.. the Table visual throws an error as soon as I select a column from the second table on the outside of the diagram...