Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
ksteever
Helper I
Helper I

Sum of values based on condition(s)

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!

1 ACCEPTED SOLUTION
miTutorials
Super User
Super User

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!

View solution in original post

2 REPLIES 2
miTutorials
Super User
Super User

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
Solution Sage
Solution Sage

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

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.