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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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