cancel
Showing results for 
Search instead for 
Did you mean: 
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
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors