Measure multiple filter help

[KevBI]

Hello Guys!

I am trying to write a Measure that Sums up one Value "Value Transaction" while using 3 Filters. 

SumValue = 

calculate(sum('COEP'[Value TranCurr]),FILTER('COEP','COEP'[Business Transaction]="COIN"

&& COEP[Name] <> "*CUT*OF*" || COEP[Name] <> "OOS*WBS"))

Do you guys see why this is not working? so my logic would be that the first (blue) condition shall always be true and than one of the red conditions would also have to be true for the value to be summed up. sadly I always get a 0 as total.

DATA:

Project ID	Business Transaktion	Value TranCurr	Name	SumValue
1	COIN	0	CUT OFF 01 2018	0
2	COIN	0	CUT OFF 03 2017	0
3	COIN	2250	Project cost	2250
4	COIN	1874	HE17RF27594.1	1874
		4124 (TOTAL)		0 (TOTAL)

[DataInsights · Accepted solution]

@KevBI,

Try this measure. Notice that I filtered COEP[Name] instead of the entire table. It's best to use column filters instead of table filters when possible.

SumValue = 
CALCULATE (
    SUM ( COEP[Value TranCurr] ),
    COEP[Business Transaction] = "COIN",
    FILTER (
        ALL ( COEP[Name] ),
        NOT CONTAINSSTRING ( COEP[Name], "*CUT*OF*" )
            || NOT CONTAINSSTRING ( COEP[Name], "OOS*WBS" )
    )
)