Problem creating a measure with Filter or Containsstring

[baneworth]

Dear all,

I created several graphs with different Filters using Calculate(sum(...)) DAX.

For my last graph i have to Filter out several BULK Hours, which is where i am facing a problem.

You can think of it as many Productnames (lets call it A,B,C,D,....) and the BULK ID's (PRDSUP-Altus, PRDSUP-Depo, PRDSUP-Flex,....).

I have to create a measure where i filter out all of the PRDSUP-***.

Current DAX i wrote as follows:

Non Productive Work = CALCULATE(SUM(EmployeeHours[TimeValueHour]),

     Filter(TaskCategory,TaskCategory[CategoryName]="Non-Productive Work" || TaskCategory[CategoryName]="Administrative"),

     FILTER(vwLPR,vwLPR[PRODUCT]<>"PRDSUP-Altus" || vwLPR[PRODUCT]<>"PRDSUP-Depo" || vwLPR[PRODUCT]<>"PRDSUP-         FSeries" || vwLPR[PRODUCT]<>"PRDSUP-Coronus" || vwLPR[PRODUCT]<>"PRDSUP-Upgrade"))/

    CALCULATE(SUM(EmployeeHours[TimeValueHour]))

I know that by using Containsstring i can use"PRDSUP*" to get everything related to that, but i can not use <> or maybe -.

Pretty sure there is an easier way to get what i want.

Appreciate everyone's time.

Best regards

[amitchandak · Accepted solution]

@baneworth , you can use search, find, containsstring

example of not

calculate( count(Table[value]), filter(Table, not search("A1", [Col1],,0) >0 ))

calculate( count(Table[value]), filter(Table, search("A1", [Col1],,0) = 0 ))

check : https://www.youtube.com/watch?v=mZt0HJw4gjQ

https://www.youtube.com/watch?v=XbgLGDvWdWQ

[baneworth]

Thanks for the superfast answer!

It worked and i checked both of your Youtube Videos.

BR