Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi,
I have an issue in computing data values in a hierarchy where certain columns need to be aggregated respecting the hierarchy, and certain columns should not. The problem statement is best explained via an Excel visual of what is happening and what I want to happen:
The report I intend to produce is in Columns B - J. I am able to produce Columns B - G correctly, but I get the values in Cols L - N instead of the Desired values in H-J
The Geo hierarchy is as follows: Region -> Region (by North/South) -> Cities
The visual is setup as a matrix, where Totals are computed at the region hierarchies.
The column descriptions are as follows:
The rest of the columns are defined via formulas:
Because of the aggregation happening on the Rookie Ramp column, the computed Investment and ROI are wrong in the TOTAL rows.
For example, the Region South Total Investment is calculated using the formula:
34 + 14 * 100% = 48 instead of using the (right) formula:
34 + 14 * 42% = 40
Any tips in how I can avoid the aggregation on the Rookie Ramp column via the appropriate DAX construct?
Thanks in advance
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
8 | |
7 | |
6 |
User | Count |
---|---|
14 | |
13 | |
11 | |
9 | |
8 |