Unable to Concatenate with unique values

[vinod57901]

Hi 

I have written the IF condition and values are coming with duplicate record then on top that I have one more column for Concatenate (comma) seperated but it showing multiple repeated values but it suppose to show unique values.

Expecting result should be like Col Name: Values(A1, A2, A3..) without repeating again same value. 

Ex: 

Dax Function I have written

Concatenated Bu Org Final =

CONCATENATEX(

   DISTINCT( FILTER(Opportunities, Opportunities[Vertical Market] = SELECTEDVALUE(Opportunities[Vertical Market]))),

    Opportunities[Bu Org Final],  //Bu Org Final column I have writtent the Nested IF condition.

    "; "

) 

Thanks

[v-yiruan-msft · Accepted solution]

Hi @vinod57901 ,

You can update the formula of measure [Concatenated Bu Org Final] as below:

Concatenated Bu Org Final = 
CONCATENATEX (
    GROUPBY (
        'Opportunities',
        'Opportunities'[Vertical Market],
        Opportunities[Bu Org Final]
    ),
    Opportunities[Bu Org Final],
    "; "
)

Best Regards

[vinod57901]

Thanks for your help.. Its near about the solution ...!!