Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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.
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.
Thanks in advance.
Solved! Go to Solution.
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.
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.
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], "; " )
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.
User | Count |
---|---|
141 | |
71 | |
70 | |
54 | |
53 |
User | Count |
---|---|
208 | |
95 | |
64 | |
61 | |
57 |