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...
ParkJE1101 , Try a measure like
divide(calculate(sum(Table[Sales]), filter(Table,Table[Category] = "Act")), calculate(sum(Table[Sales]), filter(Table,Table[Category] = "Target")))
amitchandak
Super User
Super UserParkJE1101 , 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! 😀