Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Unable to Concatenate with unique values

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

Data Protection
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

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