create an indicator to differentiate when a value doesn't contain a specific code

[Anonymous]

Using PowerBI, I have to create an indicator to differentiate when a value doesn't contain a specific code.

Example:

Invoice# SubNumber# Report Code
AL123        Al123-0            AB
AL123        AL123-1           AN
AL123        AL123-3           AC
AL124        AL124-0           AB
AL125        AL125-0           AB
AL125        AL125-1           AN

in the case above, I need to put an indicator on the invoices: AL124 AND AL125, because they don't contain Report Code "AC"

[amitchandak · Accepted solution]

@Anonymous , Try a new column like

contains AC = if(countx(filter(Table,[Invoice#] =earlier([Invoice#]) && [Report Code] ="AC"),[Invoice#] )>=1,"Yes","No")

[Anonymous]

Thank you this one worked!

[Greg_Deckler]

Put Invoice# in a Table visualization. Then create a measure like:

Measure = IF("AC" IN DISTINCT([Report Code]),1,2)

Your 2's are the invoices that do not contain "AC"