Summing with Multiple filters

[dw700d]

I am trying to create a measure that calculates the Sum of all spend for “Type” (A) where “Transpo” equals(car, boat, truck , bike)  while excluding Accounts 9,10,11. Can anyone help me with this?

Type	Spend	Account	Transpo
A	20,000,000	1	car
A	20,000,000	2	Boat
A	20,000,000	3	Truck
A	20,000,000	4	Bike
A	20,000,000	5	Plane
A	50,000,000	6	Helicopter
A	10,000,000	7	Truck
A	10,000,000	8	Bike
A	50,000,000	9	Plane
A	50,000,000	10	Helicopter
A	50,000,000	11	Scooter
B	10,000,000	3	board
B	10,000,000	3	skate

[mahoneypat · Accepted solution]

You can use this measure expression

NewMeasure =
CALCULATE (
    SUM ( Table[Spend] ),
    Table[Type] = "A",
    Table[Transpo]
        IN {
        "Car",
        "Boat",
        "Truck",
        "Bike"
    },
    NOT ( Table[Account]
        IN {
        9,
        10,
        11
    } )
)

Pat