Forum Discussion
Measure for different measures?
Hello everybody, got 5 different measures in 5 different tables. Table1, measure A Table 2, measure B Table 3, measure C Table 4, measure D Table 5, measure E all measures return a value...
NewMeasure = IF(AND(AND(AND(measure A>.9, measure B>.9), AND(measure C>.9, measure D>.9)), measure E > 0.9), ¨green¨,
IF(AND(AND(AND(measure A<.79, measure B<.79), AND(measure C<.79, measure D<.79)), measure E < 0.79), ¨red¨, ¨yellow¨))