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 statemen...
Need Help
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")

mbelobaba's avatar
mbelobaba
Frequent Visitor
5 years ago

amitchandak, well I have other conditions to be met besides the measure ID

  • mbelobaba's avatar
    mbelobaba
    Frequent Visitor
    5 years ago

    Can this be calculated in the background? Using calculatetable or something else?

    Thanks, 

    Maja

    • V-lianl-msft's avatar
      V-lianl-msft
      Community Support
      5 years ago

      Hi mbelobaba ,

       

      The logic of your formula won't work. How can a Measure ID equal two different numbers at the same time?

      You may provide some sample data and the results you expect to see if we can help you solve the problem.

      Please mask any sensitive data before uploading

       

      Best Regards,
      Liang
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.