Forum Discussion

ce138867's avatar
ce138867
Resolver II
3 years ago
Solved

Using CONCATENATEX with FILTERS

I've been reviewing previous posts about using CONCATENATEX with FILTERS and I'm seeing different answers to either create a Measure or a new column. I want to create a new Measure so that it can be ...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi ce138867 

     

    You can try this measure

    Vendors = 
CONCATENATEX (
    FILTER (
        'Hospital_Tech',
        'Hospital_Tech'[Category] = "IS Infrastructure - Software"
            && 'Hospital_Tech'[Technology] = "Wireless Carrier"
    ),
    'Hospital_Tech'[Vendor],
    "; "
)

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi ce138867 

 

You can try this measure

Vendors = 
CONCATENATEX (
    FILTER (
        'Hospital_Tech',
        'Hospital_Tech'[Category] = "IS Infrastructure - Software"
            && 'Hospital_Tech'[Technology] = "Wireless Carrier"
    ),
    'Hospital_Tech'[Vendor],
    "; "
)

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

  • ce138867's avatar
    ce138867
    Resolver II
    3 years ago

    Thanks v-jingzhang , your solution allowed me to remove the visual filter. One additional question if I may. I noticed that this gives me a concatenated list, but I'm seeing duplicates. When I try the below using DISTINCT, I'm still getting the same exact list as without using DISTINCT. Am I using DISTINCT incorrectly here? There were no errors that showed up.

     

    Vendors = CONCATENATEX(

    DISTINCT(

    FILTER ( 'Hospital_Tech', 'Hospital_Tech'[Category] = "IS Infrastructure - Software" && 'Hospital_Tech'[Technology] = "Wireless Carrier" )), 'Hospital_Tech'[Vendor], "; " )