Forum Discussion

Regular Visitor

4 years ago

Solved

Multiply conditions return different results

Hi all, New to dax here. I have one condition that I need to return values with multiplication and I was able to make it work with the syntax below VAR Sample1 = CALCULATE ([Measure1], 'Acco...

Need Help

Anonymous

4 years ago

Hi fzhang ,

You could create a measure like below:

Measure =
IF (
    SELECTEDVALUE ( 'Account'[Account Level 1] ) = "A",
    [Measure1] * 0.5,
    IF ( SELECTEDVALUE ( 'Account'[Account Level 1] ) = "B", [Measure1] )
)

Best Regards,

Jay