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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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