Adding extra condition to IF function with RELATED

[tgjones43]

Hi all

I am using the following DAX formula to check whether a value in Table 1 exceeds a set threshold, given in Table 2. This works fine, but I want to include an additional step to only say Yes if the Sign (from Table 1) is - rather then <. Current and Desired results shown in table 1, so the 2nd row should be No. Please can anyone help?

Column = IF(RELATED('Table 1'[Value])>'Table 2'[Threshold],"Yes","No")

Parameter code	Value	Sign	Current result	Desired result
A	5	-	Yes	Yes
A	5	<	Yes	No

Parameter code	Threshold
A	3

[MS_Sum · Accepted solution]

Hi @tgjones43 ,

Try the DAX formula stated below whether it works for you.

Column =

IF(

    'Table 1'[Sign] = "-",

    IF(

        'Table 1'[Value] > LOOKUPVALUE('Table 2'[Threshold], 'Table 2'[Parameter code], 'Table 1'[Parameter code]),

        "Yes",

        "No"

    ),

    "No"

)

The above one checks for the "-" sign. If it is, it checks if the value in Table 1 is greater than the threshold value in Table 2 that matches the parameter code in Table 1. If it is, then  returns "Yes", otherwise it returns "No". If the sign in Table 1 is not "-", it returns "No". 

Hope this might help you.

[tgjones43]

Hi @MS_Sum this works perfectly, thank you!