Solved: Filtering based on two criteria

Anonymous · ‎03-20-2023

Hello all.

I have a table which tells me some information related to the ParentWorkItemId, such as the Current Estimation of hours:

How can I have the sum of hours, when the ParentWorkItemId (red bellow) or the WorkItemId (black bellow) is equal to the ParentWorkItemId number on the previous table?

The Devops table is as follows:

Thank you in advance!

Anonymous · ‎03-21-2023

HI @Anonymous,

It seems like you are working with parent child hierarchy relationship requirement.

If you want to summary records according to this type of relationships, you can take a look at the following link to get the relationship path. Then you can write formula to extract the result path string to get correspond id list and use them as conditions to filter and aggregate records.

Parent-child hierarchies – DAX Patterns
Regards,

Xiaoxin Sheng

View solution in original post

Anonymous · ‎03-21-2023

HI @Anonymous,

It seems like you are working with parent child hierarchy relationship requirement.

If you want to summary records according to this type of relationships, you can take a look at the following link to get the relationship path. Then you can write formula to extract the result path string to get correspond id list and use them as conditions to filter and aggregate records.

Parent-child hierarchies – DAX Patterns
Regards,

Xiaoxin Sheng