Forum Discussion

comish4lif2's avatar
comish4lif2
Advocate II
3 years ago

Table Relationship Excluding Values

I have a table (EXAM)  with (for example) 100 unique Identifiers and some columns of data (1s and 0s for an EXAM). In a second table I have a subset of those IDs, but the table may have multiple rows...
Need Help
  • comish4lif2's avatar
    comish4lif2
    Advocate II
    3 years ago

    I appreciate your response. I don't think it is an issue of auto exist.

     

    If you look at the datatable on it's own, I get 318 rows that have that specific value.

    If I join that first datatable with a second datatable, and create a table visual, I only get 250 values. BUt I do get the row based on the member ID as a key.


    For security reasons, I am unable to provide my PBIX file.

    • lbendlin's avatar
      lbendlin
      Super User
      3 years ago

      Please provide sanitized sample data that fully covers your issue. This does not have to be your actual data.
      Please show the expected outcome based on the sample data you provided.

      • comish4lif2's avatar
        comish4lif2
        Advocate II
        3 years ago

        OK, here's a very simple version. The Master table has an ID for all MBR. The Conditions table has a Many-1 relation with the Master. A member can have 0, 1, or more Conditions.
        The Export Summary should have a row for each row in the Master and any matching data in the Conditions. 

        The desired result would look something like this: