Exlcude one dimension

[#1]

I need a bar chart showing the top 5 defects excluding any with the word 'Delay' in them.  I have not been able to get the format right for Defect not like '*Delay*' in my expression defintion.

[tresesco]

Try wildmatch()

[salto]

Hello,

the expression should exclude the value more or less like this:

count({$<DefectDescription={"*"}-{"*Delay*}>}[DefectID])

Hope this helps...

[jchoucq · Accepted solution]

hi,

i will try

count({$<DefectDescription-={"*Delay*"}>}[DefectID])

Regards,

Johann

[#5]

Hi Rob,

Check if the below expression works

wildmatch(text,'*Delay*')

Regards,

Varsha