How to calculate percentage

[NedFlanders01]

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 data

new measures for % of profit

new table to unpivot data

% of profit column is summing 😞

[jdbuchanan71 · Accepted solution]

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 )