Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don'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.

Reply
Sydsid
Frequent Visitor

Need urgent Help - Calculate new measure of top level of the hierarchy

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:

Sydsid_0-1722196668864.png

 

What i have achieved so far:

Sydsid_1-1722196715628.png

 

Link to pbix file:

https://drive.google.com/file/d/1aI3Bln9mJYtMvhBLNDpsdWcjIH8zGp-Y/view?usp=drive_link

 

Hierarchy table in pbix:

Sydsid_2-1722197116581.png

 

1 ACCEPTED SOLUTION
danextian
Super User
Super User

Hii @Sydsid 

 

The use case is very similar to this:

Sample pbix is in the video description










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


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

View solution in original post

2 REPLIES 2
danextian
Super User
Super User

Hii @Sydsid 

 

The use case is very similar to this:

Sample pbix is in the video description










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


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Thanks Danextian ! This was very helpful and solved my query,

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.