Forum Discussion
IF - multiple conditions
Hi, I'm using a matrix and having measure IDs in columns, and user names in rows. I need to create a calculated column to use it for conditional rule on measure values. I'm using IF statemen...
mbelobaba , If this is a measure. Then you need use measures of summarized columns
example
IF(AND(max(Table[measure_id])=7 && sum(Table[value])<=sum(Table[target]),max(Table[measure_id])=8 && sum(Table[value])>=sum(Table[target])),1)
Hi amitchandak,
I'm using calculated column with multiple IF statement for every measure.
Thanks,
Maja
mbelobaba , what is the challenge. You can color green when value of the measure on top this column is 1.
or can create a color measure and use it with field value.
if([Measure]=1, "green", "white")
amitchandak, well I have other conditions to be met besides the measure ID
