Forum Discussion

mbelobaba's avatar
mbelobaba
Frequent Visitor
5 years ago

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 statements and it's working for a calculation on a single measure but what I need now is to set a calculation to look if two measures are reached the target. If both reached, then both should be green. If one did not reach the target, then both should stay white. 

 

I tried this but it's not working as needed:
IF(AND(Table[measure_id]=7 && Table[value]<=Table[target],Table[measure_id]=8 && Table[value]>=Table[target]),1)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Any ideas how can this be resolved?

 

Thank you, 

Maja

Need Help

6 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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)

    • mbelobaba's avatar
      mbelobaba
      Frequent Visitor
      5 years ago

      Hi amitchandak, 

      I'm using calculated column with multiple IF statement for every measure. 

       

      Thanks, 

      Maja

      • amitchandak's avatar
        amitchandak
        Super User
        5 years ago

        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")