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.
Hello all,
I have one question/Issue with DAX in statement IF
I try to make a flag, but if i used < my data is empty ... I don't know why...
Check my print screen
Try this:
AmountPrime=
Var _A = 120%
return
if([Med%]<_A,"Yes","False")
If it does not work, can you share a [Med%] measure code here?
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos✌️!!
not ...
Hey,
the IF-Function is defined like this: IF(<logical_test>, <value_if_true>, <value_if_false>)
If I see it correctly, you missed the "else" statement.
Regards
@Anonymous it's same ...
hmmm... but if you don't inserte the measure there is data displayed?
What does the [Med%] measure do?
@Anonymous
Last guess...
if( Ref <> blank() && Curr <> blank() && ([Med%]<1.2), "yes", "no")
Because I don't understand why there is no data displayed ;D
Regards
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |