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
NithinBN
Helper II
Helper II

Actual vs Target

Hello All,

 

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

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

ProductSales
Bike100
Bike200
Bike300
Bike400
Cloths50
Cloths60
Cloths70
Cloths80
Others250
Others300
Others350
Others400

how can I display table something like this ?

 TargetSales(Sales\Tar)*100
Bike8001000125
Cloths50026052
Others12501600128
Total25502860112

 

Or any other better way to represent ?

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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

 

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@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

 

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.