Forum Discussion

ce138867's avatar
ce138867
Icon for Resolver II rankResolver 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
Icon for Community Support rankCommunity 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.