Merging Lines

Hi,Anonymous 

I am glad to help you.  

According to your description, you want to merge these lines together to be only three lines? 

 

If I understand you correctly, then you can refer to my solution. 

 

First you need to create a table for the corresponding Deals, remembering to establish a relationship for both tables: 

 

Then New Column: 

 

 

MergeCompany = 
SWITCH (
    TRUE (),
    'Table1'[Deals] = 3,
        CONCATENATEX (
            FILTER ( 'Table1', 'Table1'[Deals] = 3 ),
            'Table1'[Company],
            ","
        ),
    'Table1'[Deals] = 2,
        CONCATENATEX (
            FILTER ( 'Table1', 'Table1'[Deals] = 2 ),
            'Table1'[Company],
            ","
        ),
    'Table1'[Deals] = 1,
        CONCATENATEX (
            FILTER ( 'Table1', 'Table1'[Deals] = 1 ),
            'Table1'[Company],
            ","
        )
)

 

Finally drag the newly created Column field into Tooltips and this is the final result: 

 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,
Fen Ling,

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