cancel
Showing results for
Did you mean:
Frequent Visitor

## Getting a aggregate (MAX) for a parent group based on an aggregate calculations at a sub group level

Good day,

Need some help figuring out how to get a aggregate (MAX) for a parent group based on an aggregate calculations at a sub group level.  Note, there is a date column in the dataset that will be used by a date slicer on the page.

Column A = Parent Group
Column B = Sub Group
Column C = Calculation based on Column B (Sub Group)
Column D = Max value in Column C grouped by Column A

 Parent Sub group Conversion Expected Value A ABCD 89.9% 91.7% A BCDE 82.2% 91.7% A CDEF 72.8% 91.7% A DEFG 87.7% 91.7% A EFGH 78.6% 91.7% A FGHI 80.9% 91.7% A GHIJ 91.7% 91.7% A Total 73.7% 91.7% B HIJK 71.2% 85.5% B IJKL 85.5% 85.5% B JKLM 78.4% 85.5% B KLMN 59.5% 85.5% B LMNO 57.5% 85.5% B MNOP 69.7% 85.5% B Total 74.7% 85.5%
1 ACCEPTED SOLUTION
Community Support

Hi @QuazarP ，

Based on your description, you can create a measure as follows.

`max_value = MAXX(FILTER(ALLSELECTED('Table 2'),'Table 2'[Parent]=SELECTEDVALUE('Table 2'[Parent])),'Table 2'[Conversion])`

Result:

Hope that's what you were looking for.

Best Regards,

Yuna

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

4 REPLIES 4
Frequent Visitor

Thanks @v-yuaj-msft,  I ended up needing to wrap a SUMMERIZE around the table in DAX to work with the final dataset.

Community Support

Hi @QuazarP ，

Based on your description, you can create a measure as follows.

`max_value = MAXX(FILTER(ALLSELECTED('Table 2'),'Table 2'[Parent]=SELECTEDVALUE('Table 2'[Parent])),'Table 2'[Conversion])`

Result:

Hope that's what you were looking for.

Best Regards,

Yuna

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

Super User I

you can using summarize create a table that summarizes the parent group

max aggregate = SUMMARIZE('Table', 'Table'[Parent], "MAX Agg", MAX('Table'[Conversion]))

Proud to be a Super User!

Frequent Visitor

Thanks, vanessafvg but I don’t think this option works as the page will also have a date slicer that would be used against the dataset.  I am updating the original message to call out that challenge also.

Announcements