Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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!
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!
Please share a sample of your data and screenshot of your model. And maybe a mock-up of your desired output visual.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
96 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |