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.

ce138867's avatar
ce138867
Resolver II
3 years ago

After reviewing this I think I was able to solve this but would like some recommendations if this is the best way to do this.  

First, I reviewed this post: https://community.powerbi.com/t5/Desktop/Concatenate-rows-with-filter/m-p/155779#M67448 and created a measure that used the concatenatex function for the Vendor Column. Then I created a card with that measure and applied a filter just for that visual that is Technology = Wireless Carrier.