Using an if statement with a related table.

[Michaelbean21]

I am trying to create an if statement to see if one value on a table is blank and another value on another table equals whatever.  I am getting the result as follows, does anyone know how to resolve this issue?

[Samarth_18 · Accepted solution]

Hi @Michaelbean21 ,

Please try this:-

Estimated premius bank =
IF (
    FACT_BookOfBusiness[Estimated Premius] = BLANK ()
    && RELATED ( DIM_LineStatus[Line Status Code] ) IN { "AQR", "CAI", "CCQ" ....},//add your values of if condition inside " ".
    "Audit",
    "No Audit"
)

Thanks,

Samarth

[Michaelbean21]

Thank you much for your help on this! Been trying to figure this out for over a week now.