DAX: Operator or expression '( )' is not supported in this context

[Steuben]

I'm trying to make a measure to help me with some conditional formatting. Sadly, I'm running into a new error for me when trying to be fancy with some nested IFs. I know there's a way to do this, but for the life of me I can't figure it out! When I use the below code I get the following error message: "Operator or expression '( )' is not supported in this context". 

Inverse_ind_formatting =

IF([Inverse_ind_measure] = 1 && ('Compare_Monthly Extracts_Data'[Rate_Variance] < 0,[Rate_Variance] >-99999),-1,

IF([Inverse_ind_measure] = 1 && ('Compare_Monthly Extracts_Data'[Rate_Variance] <0.05,[Rate_Variance]>0),-2,

IF([Inverse_ind_measure] = 1 && ('Compare_Monthly Extracts_Data'[Rate_Variance]<0.1,[Rate_Variance]>0.05),-3,

IF([Inverse_ind_measure] = 1 && ([Rate_Variance]<99999,[Rate_Variance]>0.1),-4))))

[ToddChitt · Accepted solution]

You have and extra ( at the start of this:

('Compare_Monthly Extracts_Data'[Rate_Variance] < 0,[Rate_Variance] >-99999)

Try formatting with tabs:

IF ( <Condition 1>, <true>,

       IF (<condition 2>, <true>, 

           IF ( <condition 3>, >true>, <false> )

       )

 )

That helps line up the ( and the )

[Steuben]

That sure did the trick, thank you!! I had those extra () in there because a few iterations ago I was messing around with using AND...but I forgot to remove that and replace it with some more &&. Here's the final code I used that ended up working beautifully. I did do the tabs I swear, I just isn't coming through nicely when I paste it.

Inverse_ind_formatting =
IF([Inverse_ind_measure] = 1 && 'Compare_Monthly Denodo Extracts_Data'[Rate_Variance] < 0 && [Rate_Variance] >-99999,-1,
IF([Inverse_ind_measure] = 1 && 'Compare_Monthly Denodo Extracts_Data'[Rate_Variance] <0.05 && [Rate_Variance]>0,-2,
IF([Inverse_ind_measure] = 1 && 'Compare_Monthly Denodo Extracts_Data'[Rate_Variance]<0.1 && [Rate_Variance]>0.05,-3,
IF([Inverse_ind_measure] = 1 && [Rate_Variance]<99999 && [Rate_Variance]>0.1,-4))))