Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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],...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    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.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

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.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, Anonymous ;

You could use ISINSCOPE or HASEONEVALUE function,about some links as follow:

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Display-Values-without-including-in-calculation/m-p/2420231#M64078

https://docs.microsoft.com/en-us/dax/hasonevalue-function-dax

 

Or you could provide a simple file.


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.