Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi
I need to show new measure "Gross Profit" = "Total Income" - "Total Cogs". Both Total Income and Total COGS are the top of the hierarchy with other line item underneath. Both these are running totals. After the run calculation Gross Profit need to be shown at the same row level as Total Income and Total Cogs. Below are the screen shots of what i need to achieve and what i have achieved so far.
What i need to achieve:
What i have achieved so far:
Link to pbix file:
https://drive.google.com/file/d/1aI3Bln9mJYtMvhBLNDpsdWcjIH8zGp-Y/view?usp=drive_link
Hierarchy table in pbix:
Solved! Go to Solution.
Hii @Sydsid
The use case is very similar to this:
Sample pbix is in the video description
Proud to be a Super User!
Hii @Sydsid
The use case is very similar to this:
Sample pbix is in the video description
Proud to be a Super User!
Thanks Danextian ! This was very helpful and solved my query,
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
124 | |
79 | |
50 | |
38 | |
38 |
User | Count |
---|---|
196 | |
80 | |
70 | |
51 | |
42 |