I have 3 measures, and I want to add measure1
and measure2
and then subtract measure3
from the result. I'm unable to get the composite metric below to work. Any help would be appreciated.
subtract([
sum([
sum(s("measure1", "*")),
sum(s("measure2", "*")),
]),
sum(s("measure3", "*"))
])