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 bu...
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

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 ...!!