Repeating Values Across Categories

hello Pavithra_Ramesh 

please check if this accomodate your need.

1. create a new calculated column with following DAX.

Count =
COUNTX(
    FILTER(
        'Table',
        'Table'[Table Name]=EARLIER('Table'[Table Name])
    ),
    'Table'[Lab ]
)

2. create a new table with following DAX.

SUMMARIZE(
    FILTER(
        'Table',
        'Table'[Count]>1
    ),
    'Table'[Table Name],
    "Labs",
    CONCATENATEX(
        'Table',
        'Table'[Lab ],
        ", "
    )
)

Hope this will help.

Thank you.

Hi Pavithra_Ramesh 

If you need to show all the labs by table you can use the formula 

TBLS = CONCATENATEX(DISTINCT('Table'[Lab ]),'Table'[Lab ],",")

if only repeatings

TBLS_2 =

VAR

 COUNTROWS_= COUNTROWS(VALUES('Table'[Lab ]))

 RETURN

 IF(COUNTROWS_>1,

 CONCATENATEX(DISTINCT('Table'[Lab ]),'Table'[Lab ],","),BLANK())

The pbix is attached

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

Hi Pavithra_Ramesh 

Thanks for the reply from Irwan and Ritaf1983, please allow me to provide my method:

Create two measures as follow:

TableCount = 
COUNTROWS(
    CALCULATETABLE(
        'Table',
        ALLEXCEPT('Table', 'Table'[Table Name])
    )
)

TablesInAllLabs = 
CALCULATE(
    CONCATENATEX(
        VALUES('Table'[Lab]),
        'Table'[Lab],
        ", "
    ),
    FILTER(
        'Table',
        [TableCount] = COUNTROWS(ALL('Table'[Lab]))
    )
)

Output:

Best Regards,
Yulia Xu

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

Thank you all. This gave me direction. Here is what I used: 

1. Create a Calculated Table

DistinctSourceLab =

SUMMARIZE(

'Table',

'Table'[Source],

'Table'[Lab]

)

2. Create a Measure

Lab_Sources_Concat =

VAR CurrentSource = SELECTEDVALUE('Table'[Source])

RETURN

CONCATENATEX(

FILTER(

DistinctSourceLab,

DistinctSourceLab[Source] = CurrentSource

),

DistinctSourceLab[Lab],

", "

)

Hi,

PBI file attached.

Hope this helps.