Visual for Difference between Profit and cost

Question

Data table 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Calculated column&nbsp;PersonProduct NumberJob TitleHoursRatesCost&nbsp;SandraKICK 1Managing Partner501005000&nbsp;PriscillaKICK 2Business Director25802000&nbsp;BestyKICK 3Account Director12.560750&nbsp;AlbertaKICK 4Account Manager6.2540250&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Data table 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PersonProduct NumberJob TitleRevenue KPI&nbsp;&nbsp;&nbsp;SandraKICK 1Managing Partner10000&nbsp;&nbsp;&nbsp;PriscillaKICK 2Business Director5000&nbsp;&nbsp;&nbsp;BestyKICK 3Account Director2500&nbsp;&nbsp;&nbsp;AlbertaKICK 4Account Manager1250&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;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 Answer

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]))

Forum Discussion

Visual for Difference between Profit and cost

2 Replies

Related content

Different schema into different destination

Map visual differences

Different calculations for same visual

Different measures in Matrix visual

HTML VizCreator Cert on different Visual

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