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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
NedFlanders01
Frequent Visitor

How to calculate percentage

Hello,

I am attempting to recreate a Tableau dashboard and the data that was provided to me is in a pivot format. I've managed to unpivot the columns Revenue, Cost, Profit and % of Profit for the matrix table. The issue I am facing is that the column, % of profit is summing up rather than returning the single value for a given team and month.  Is there a way to prevent the % of profit from summing? Any advice / tips would be greatly appreciated. 

 

Original dataOriginal data

 

new measures for % of profitnew measures for % of profit

new table to unpivot datanew table to unpivot data

% of profit column is summing :(% of profit column is summing 😞

1 ACCEPTED SOLUTION
jdbuchanan71
Super User
Super User

Hello @NedFlanders01 

You can write a measure to calculate the % of profit correctly:

 

% of Profit Measure =
VAR RevenueSum = SUM ( table[Revenue] )
VAR ProfitSum = SUM ( table[Profit] )

RETURN
	DIVIDE ( ProfitSum, RevenueSum )

View solution in original post

1 REPLY 1
jdbuchanan71
Super User
Super User

Hello @NedFlanders01 

You can write a measure to calculate the % of profit correctly:

 

% of Profit Measure =
VAR RevenueSum = SUM ( table[Revenue] )
VAR ProfitSum = SUM ( table[Profit] )

RETURN
	DIVIDE ( ProfitSum, RevenueSum )

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors