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
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.