Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Combine data from two tables into two different columns

Hi,   I want to create two measures that i can drag into a table visual against a common column.   The data is as following Table 1:   Table 2   Final Desired Table- I wish to dr...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

    Please refer to my pbix file to see if it helps you.

    The first way:
    Using Tahreem24 's method： Create relationship

    Another way: Do not need to create relationships. 

    Create a measure:

    Measure =
CALCULATE (
    MAX ( 'Table'[Segment] ),
    FILTER (
        ALL ( 'Table' ),
        'Table'[CONTACT_ID] = SELECTEDVALUE ( Table_1[contact_id] )
    )
)

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

     

Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
4 years ago

Anonymous You need to have a relationship between these two tables based on common key (let's say Contact_ID) then you can drag them all together.