Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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], 'Account'[Account Level 1] = "A")
RETURN
[Measure1] * 0.5
Now I need to include another condition where if 'Account'[Account Level 1] = "B", return [Measure1]
How should I write it?
Thanks!
Solved! Go to Solution.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
69 | |
69 | |
43 |
User | Count |
---|---|
146 | |
106 | |
104 | |
89 | |
65 |