PowerBi. Concatenate table rows in one string
 
	
If you want to make a string of values in Power BI, you can use the formula like this. It will join all the values, which correspond to the condition, in one line.
I advise you to use Measure for this instead of new columns.
Topics = 
VAR __DISTINCT_VALUES_COUNT = DISTINCTCOUNT('MarketTable5'[Topic])
VAR __MAX_VALUES_TO_SHOW = 500
RETURN
	CONCATENATEX(
	FILTER(VALUES('MarketTable5'[Topic]), 'MarketTable5'[Topic] <> ""),
		'MarketTable5'[Topic],
		", ",
		'MarketTable5'[Topic],
		ASC
	)You can insert this measure into the Visual 'Card' and apply filters.
