Forum Discussion
Measure with IF OR
Hi All, I am trying to create a measure based below condition I have Sales and Cost Measure,I need to calculate margin based on below IF (Sales[Region] in {"FPT","BRT","ZXT"}|| LEFT(Sales[Region],...
Hi, Anonymous ;
Try to create a measure.
Result = VAR a = SUM ( Sales[SalesAmt] ) RETURN IF ( MAX ( Sales[Region] ) IN { "FPT", "BRT", "ZXT" } || LEFT ( MAX ( Sales[Region] ), 3 ) = "FRT", a, a - SUM ( Sales[Margin] ) )If not right, can you share a simple example so that we can better test it?
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous , Try this:
Result =
var value1 = LEFT(Sales[Region],3)
var a = sum(Sales[SalesAmt])
var b = sum(Sales[SalesAmt])-sum(Sales[Margin])
RETURN
IF (
Sales[Region] in {"FPT","BRT","ZXT"}
|| value1 in {"FRT"},
a, b
)
I get error single value for Region in table Sales cannot be determined.