Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
User | Count |
---|---|
16 | |
15 | |
14 | |
12 | |
11 |
User | Count |
---|---|
19 | |
15 | |
14 | |
11 | |
9 |