Forum Discussion
Post ProdigyMeasure IF VALUE "" THEN ...
Hi,
I have an issue in creating a measure that depends on another table and value.
The logic would be :
IF Actual LCR = "" THEN "" , Otherwise AVERAGE(Rate_Card_Table[Rate Card Value])
I tried the following but it gives me an error:
Hello cristianml ,
as Actual LCR is formated as number, you have to check for 0 or blank().
So the formula should look like
IF ([Actual LCR] = BLANK(),BLANK() ,AVERAGE(Rate_Card_Table[Rate Card Value]))
If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun
Jimmy
1 Reply
Jimmy801Community Champion
Hello cristianml ,
as Actual LCR is formated as number, you have to check for 0 or blank().
So the formula should look like
IF ([Actual LCR] = BLANK(),BLANK() ,AVERAGE(Rate_Card_Table[Rate Card Value]))
If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun
Jimmy