Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |