cancel
Showing results for
Search instead 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.

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%
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]))

Did I answer your question? Mark my post as a solution!

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.

Helpful resources

Announcements

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Check it Out!

Click here to read more about the April 2021 Updates!

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors