Help with Sumifs functionality

[Anonymous]

Hello,

I am very new to Power BI Desktop, and am looking for some help with an added column.  I have two tables in my model, and I am looking for the equivalent of a SumIFS based on 3 criteria matching between the two sheets.  Table 1(Workplan Summary) is a list of all emplyee, their project, and week ending, with a number for the hours they should spend in those weeks.

Table 2(Timesheet Data) is a data dump from a timekeeping system where they enter the time they spend every week.  I need to take the sum of data in table 2, matched on the employee name, week ending date, and the project name, and have that value in a new column in table 1, so that the data can be represented and filtered properly with slicers.  I read through some threads here and came up with the following formula, and it is returning no values.  Can anyone point out where there might be some issues?

Actual Hours = SUMX('Timesheet Data',IF(AND('Timesheet Data'[Activity]='Workplan Summary'[Project Number],AND('Timesheet Data'[Description]='Workplan Summary'[Resource],'Timesheet Data'[End Date]='Workplan Summary'[Week Ending])),CALCULATE(SUM('Timesheet Data'[Quantity])),BLANK()))

[Greg_Deckler · Accepted solution]

So typically you would implement that like:

Actual Hours = 
SUMX(FILTER('Table',<criteria>),<column to sum>)

Difficult to be specific without knowing your data and how your tables are related. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490