Sum of values based on condition(s)

[ksteever]

I have a table of issues from our organizations work management system (Jira). Each issue can be linked to a parent issue which has it's own column in my data set (ParentLink). Is there a way that I can grab the list of Parent issues, put it into a new table, eliminate all duplicates values, then do a search for every time that value exists. When it finds the value, it should do a sum function every time it finds that value of the "story points" column in the row if the "status category" column says in progress. 

I could do this in excel in like 5 minutes with something like the below but I'm struggling with how I can do this in PowerBI.

=sumifs(B:B, A:A, A2, C:C, "In Progress") 

Any help is hugely appreciated!

[miTutorials · Accepted solution]

The below dax is provided based on the excel formula that you have provided. If this does not work please provide more information.

TotalInProgress = 
    CALCULATE(
        SUM('YourTable'[B]),
        'YourTable'[A] = MAX('YourTable'[A2]),
        'YourTable'[C] = "In Progress"
    )

Best regards,

Ismail | 🎥 MiTutorials on YouTube
Explore over 200+ Power BI tutorials and enhance your skills!

[CoreyP]

Please share a sample of your data and screenshot of your model. And maybe a mock-up of your desired output visual.