Help with Switch Function

DAX DAX Calculations
4

Matthew,

You can use the or function.

need || after each TRUE.

Would look something like this:

Billing Issue =
SWITCH (
    TRUE (),
    CIP_DATA[covered_icd_code_required] = TRUE
        || CIP_DATA[credentialing] = TRUE
        || CIP_DATA[documentation] = TRUE
        || CIP_DATA[icd_lcd_ncd] = TRUE
        || CIP_DATA[lack_of_missing_documentation] = TRUE
        || CIP_DATA[medical_necessity] = TRUE
        || CIP_DATA[medical_records_required] = TRUE
        || CIP_DATA[modifier] = TRUE
        || CIP_DATA[need_alternative_code] = TRUE
        || CIP_DATA[need_medical_necessity_letter] = TRUE
        || CIP_DATA[pre_auth] = TRUE
        || CIP_DATA[signature] = TRUE, "Billing Issue",
    BLANK ()
)

Or you could use an IF statement if you only have two possible outcomes. That would look something like this:

Billing Issue =
IF (
    CIP_DATA[covered_icd_code_required] = TRUE
        || CIP_DATA[credentialing] = TRUE
        || CIP_DATA[documentation] = TRUE
        || CIP_DATA[icd_lcd_ncd] = TRUE
        || CIP_DATA[lack_of_missing_documentation] = TRUE
        || CIP_DATA[medical_necessity] = TRUE
        || CIP_DATA[medical_records_required] = TRUE
        || CIP_DATA[modifier] = TRUE
        || CIP_DATA[need_alternative_code] = TRUE
        || CIP_DATA[need_medical_necessity_letter] = TRUE
        || CIP_DATA[pre_auth] = TRUE
        || CIP_DATA[signature] = TRUE,
    "Billing Issue",
    BLANK ()
)

Thanks
Jarrett