Measure that generates a list in text format based on certain criteria

[Anonymous]

Hi all,

I have a data table similar to the below:

Fruit	Quantity
Apple	12
Pear	2
Banana	5
Orange	7
Kiwi	2
Melon	3
Grapefruit	4
Peach	1

I need to create a measure that finds the fruit that have a quantity less than 3, and then displays the names of those fruits in a text box (or card visual, whatever's easiest). So for the above example, the text box will display the following:

"Pear, Kiwi, Peach"

The quanitites of fruit will change on a weekly basis, so one week this text box could contain 3 fruits, the next 1, the next 7... and I need the text box to automatically update to reflect this, keeping the same format (i.e. each fruit separated by a ",")

Thanks

[amitchandak · Accepted solution]

@Anonymous , Hope Quantity is a column

then

Concatenatex(Filter(Table, Table[Quantity] <3) , Table[Fruit])

[Anonymous]

Thanks!