SUMIFS to Dax

[User5231]

I previously posted about this and got a solution, but really still didn't have what I needed.

How can I replicate this SUMIFS in Dax?

Previous solution did not have the "Part" Criteria.

If there were not multiple parts per date, solution is...

=CALCULATE(SUM(Data[Qty]),FILTER(Data,Data[Scheduled Finish Date]<EARLIER(Data[Scheduled Finish Date])&&Data[Actual Finish]>=EARLIER(Data[Scheduled Finish Date])))

How do I add a third criteria that says sum qty on dates less than date in that row && actual finish >= the schedule date && unique to part number??

Thanks

[negi007 · Accepted solution]

@User5231 Can you try below dax in your calculated column

PastDue =

CALCULATE(

SUM('Table'[Qty]),

FILTER(ALL('Table'),'Table'[Schedule finish]<EARLIER('Table'[Schedule finish])),

FILTER(ALL('Table'),'Table'[Actual finish]>=EARLIER('Table'[Schedule finish])),

FILTER(ALL('Table'),'Table'[Part]=EARLIER('Table'[Part])

)

)

[User5231]

Yes I figured that out as well! Thanks for the input!