Filter to show all items where contains

[dkalina97]

This seems like it should be an easy query but I am struggling. From my Sales table, I would like to bring in all invoices and items, where one of the items on the invoice contains "Coupon" in order to view all invoices and items that were discounted.

[olgad]

Hi, if it is a measure then

M1=
Calculate(Sum(Table[Invoices]), Filter(Table,CONTAINSSTRING(min(Table[Invoice/Or whatever column you are checking]), "Coupon")=true))

If it is a column then you can check true false or like that, see the example