Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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% |
Solved! Go to 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.
Thanks @v-yuaj-msft, I ended up needing to wrap a SUMMERIZE around the table in DAX to work with the final dataset.
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.
you can using summarize create a table that summarizes the parent group
Proud to be a Super User!
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |