topic Unable to Concatenate with unique values in Developer

Unable to Concatenate with unique values

Anonymous — Fri, 15 Sep 2023 11:22:46 GMT

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

Re: Unable to Concatenate with unique values

Anonymous — Mon, 18 Sep 2023 06:22:53 GMT

Hi @Anonymous ,

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

Re: Unable to Concatenate with unique values

Anonymous — Wed, 20 Sep 2023 12:56:30 GMT

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