Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
ce138867
Resolver II
Resolver II

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 displayed as a Card based on a page filter. 

 

  • The page filter can be set for an organization
  • Based on filters in the same table, concatenate the values into one string
  • The Measure is one of multiple that is being created to show different pieces of data separately

I was getting an error previously that stated: "A table of multiple values was supplied where a single value was expected." I've been playing with this measure for awhile and wondering if anyone has any recommendations.

With the below query, I'm now getting "Too many arguments were passed to the FILTERS function. The maximum argument count for the function is 1."

Basically if the below filters are applied, I want to display the values from the Vendor Column in this Hosp_Tech table as one string. E.g. if it's Tmobile and Sprint, I want the measure to output both so I can pull into a Card visual.

 
WC =
CONCATENATEX (
    summarize(
        filters(
            Hosp_Tech, Hospital_Tech[CATEGORY] = "IS Infrastructure - Software"
            && Hospital_Tech[TECHNOLOGY] = "Wireless Carrier")
)
)

Thanks in advance.

1 ACCEPTED SOLUTION
v-jingzhang
Community Support
Community Support

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],
    "; "
)

vjingzhang_0-1683697170270.png

 

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

View solution in original post

3 REPLIES 3
v-jingzhang
Community Support
Community Support

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],
    "; "
)

vjingzhang_0-1683697170270.png

 

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

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], "; " )

ce138867
Resolver II
Resolver II

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. 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.