Visual for Difference between Profit and cost

[sandrasamoah]

Data table 1
					Calculated column
Person	Product Number	Job Title	Hours	Rates	Cost
Sandra	KICK 1	Managing Partner	50	100	5000
Priscilla	KICK 2	Business Director	25	80	2000
Besty	KICK 3	Account Director	12.5	60	750
Alberta	KICK 4	Account Manager	6.25	40	250
Data table 2
Person	Product Number	Job Title	Revenue KPI
Sandra	KICK 1	Managing Partner	10000
Priscilla	KICK 2	Business Director	5000
Besty	KICK 3	Account Director	2500
Alberta	KICK 4	Account Manager	1250

Hi I am trying to subtract the cost from the revenue above for the two different tables on 1 visual but I am struggling. I tried using the KPI but i doesnt show the difference.

[Greg_Deckler · Accepted solution]

Relate the two tables on Person or you may need a Person bridge table with unique values and relate both tables to it. You should then be able to create a measure like:

RevenueCost = [Revenue KPI] - SUM(RELATED(Table1[Cost]))

[sandrasamoah]

Thanks, I am grateful. I had been grappling with this for a while.