Can't filter 3 or more criteria, need help

[scr5jo]

Hi Guys,

I'm trying to filter with 3 criteria and PowerBi says it can't filter more than 2.
How can I solve this issue?

Here is the code, and I'm trying to just sum a total to the open purchase requisitions.

Current PurReqs =
VAR Material = SELECTEDVALUE(PurReqs[Material])
return
CALCULATE(
SUMX( PurReqs, PurReqs[Qty]),
FILTER(
ALL(PurReqs[Material] ,PurReqs[Category], PurReqs[SchedDate]),
PurReqs[Material] = Material ,
PurReqs[Category] = "PurReqs",
PurReqs[SchedDate] <= TODAY())
)

Thanks!

 

[jorismoerings]

try this:

Current PurReqs =
VAR Material = SELECTEDVALUE(PurReqs[Material])
return
CALCULATE(
SUMX( PurReqs, PurReqs[Qty]),
FILTER(
ALL(PurReqs[Material] ,PurReqs[Category], PurReqs[SchedDate]),
PurReqs[Material] = Material &&
PurReqs[Category] = "PurReqs"&&
PurReqs[SchedDate] <= TODAY())
)