Forum Discussion
Solved
Target achievement % calculation & showing graph
Dear. Experts,
I have raw Excel table like below.
| Category | Quarter | Sales |
| Act 2020 | Q1 | 5 |
| Act 2020 | Q2 | 15 |
| Act 2020 | Q3 | 10 |
| Act 2020 | Q4 | 10 |
| Act 2021 | Q1 | 10 |
| Act 2021 | Q2 | 20 |
| Act 2021 | Q3 | 15 |
| Act 2021 | Q4 | 25 |
| Target 2021 | Q1 | 15 |
| Target 2021 | Q2 | 20 |
| Target 2021 | Q3 | 30 |
| Target 2021 | Q4 | 40 |
How can I calculate Target achievement % by Quarter and show with bar or line graph?
For example, 2021 Q1 target achievement % should be calculated 10/15=66.7%
ParkJE1101 , Try a measure like
divide(calculate(sum(Table[Sales]), filter(Table,Table[Category] = "Act")), calculate(sum(Table[Sales]), filter(Table,Table[Category] = "Target")))
2 Replies
- amitchandak
Super User
ParkJE1101 , Try a measure like
divide(calculate(sum(Table[Sales]), filter(Table,Table[Category] = "Act")), calculate(sum(Table[Sales]), filter(Table,Table[Category] = "Target")))
Thanks Amitchandak! I solved issue! 😀
