Forum Discussion
Correct total sum
Hello, I am having trouble with a formual its simple just multiplying Total - Actual column by the Target % to give me the Total # per below table in red. The sum however is not working its multipl...
Mahesh0016
Super User
Super UserAnonymous
Target # =
SUMX(
FILTER(
'Data',
'Data'[Region] = "Canada")
, [Total - Actual]* [Target %]
)
, [Total - Actual]* [Target %]
)
*If this post helps, please consider accept as solution to help other members find it more quickly and Appreciate your Kudos.