Actual vs Target

[NithinBN]

Hello All,

I have below table, I have defined Targets for each product,

for Bike =800, Cloths = 500, Others =1250,

Product	Sales
Bike	100
Bike	200
Bike	300
Bike	400
Cloths	50
Cloths	60
Cloths	70
Cloths	80
Others	250
Others	300
Others	350
Others	400

how can I display table something like this ?

	Target	Sales	(Sales\Tar)*100
Bike	800	1000	125
Cloths	500	260	52
Others	1250	1600	128
Total	2550	2860	112

Or any other better way to represent ?

[amitchandak · Accepted solution]

@NithinBN , Load The target into a table with columns

Product Target

Create a common product table and join both with Product and then you can analyze sales and target together,

Then you have measure like this and display against the Product from the product table

Sales M= sum(Sales[sales])
Target M = Sum(Target[Target])

Diff= divide([Sales M],[Target M])

How to create a bridge/common dimension Table

https://youtu.be/Bkf35Roman8