Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 ?
Solved! Go to 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
@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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |