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

[Anonymous]

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.

Please see below:
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%

[Anonymous]

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

[v-yuaj-msft · Accepted solution]

Hi @Anonymous ，

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.

[vanessafvg]

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

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

[Anonymous]

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.