Forum Discussion

yogeshk77's avatar
yogeshk77
Helper I
4 years ago
Solved

Max from related table

I need to get "Max" of related value from the child table.   Here is my data structure  Parent Table "Stories"   Child Table "Build Work Item" (Related by Work Item ID field) Now, i...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi yogeshk77 ,

     

    I add some dummy data to the Build WI table.

     

    Here's the solution.

    1.Relationship is as follows.

     

    2.[Build ID] is from Build WI table, and the aggregation operation selects the maximum. [Work Item ID] is from Stories table.

     

     

    3. If you want the measure to display the maximum value, you can create the following measure.

     

    Latest Build ID = CALCULATE(MAX('Build WI'[Build ID]),ALLEXCEPT('Stories',Stories[Work Item Id]))

     

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi yogeshk77 ,

 

I add some dummy data to the Build WI table.

 

Here's the solution.

1.Relationship is as follows.

 

2.[Build ID] is from Build WI table, and the aggregation operation selects the maximum. [Work Item ID] is from Stories table.

 

 

3. If you want the measure to display the maximum value, you can create the following measure.

 

Latest Build ID = CALCULATE(MAX('Build WI'[Build ID]),ALLEXCEPT('Stories',Stories[Work Item Id]))

 

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.