adding if statement in a Measure DAX

Question

I am using the following DAX in the measure below:

UPS %No Maint Bypass =
VAR TotalMaintBypass =
    COUNTROWS (
        FILTER ( ALL ( 'UPS (2)' ), 'UPS (2)'[UPS Maintenance Bypass] = "TRUE" )
    )
        + COUNTROWS (
            FILTER ( ALL ( 'UPS (2)' ), 'UPS (2)'[UPS Maintenance Bypass] = "FALSE" )
        )
        + COUNTROWS (
            FILTER (
                ALL ( 'UPS (2)' ),
                'UPS (2)'[Redundant UPS Maintenance Bypass] = "TRUE"
            )
        )
        + COUNTROWS (
            FILTER (
                ALL ( 'UPS (2)' ),
                'UPS (2)'[Redundant UPS Maintenance Bypass] = "FALSE"
            )
        )
VAR NoMaintBypass =
    COUNTROWS (
        FILTER ( ALL ( 'UPS (2)' ), 'UPS (2)'[UPS Maintenance Bypass] = "FALSE" )
    )
        + COUNTROWS (
            FILTER (
                ALL ( 'UPS (2)' ),
                'UPS (2)'[Redundant UPS Maintenance Bypass] = "FALSE"
            )
        )
RETURN
    DIVIDE ( NoMaintBypass, TotalMaintBypass, 0 ) * 100 + 0

how can I add the if statement ('UPS (2)', IF('UPS (2)'[Redundant UPS] = "TRUE") when UPS (2)'[Redundant UPS Maintenance Bypass] is used. In 3 places.

Any assistance is appreciated.

could you pls elaborate more on this? or pls provide some sample data and expected output. — Ryan
– Ryan, Commented May 14 at 9:40

cghanta · Accepted Answer · 2025-05-14 16:13:30Z

UPS %No Maint Bypass = VAR TotalMaintBypass = COUNTROWS(FILTER(ALL('UPS (2)'), 'UPS (2)'[UPS Maintenance Bypass] = "TRUE")) + COUNTROWS(FILTER(ALL('UPS (2)'), 'UPS (2)'[UPS Maintenance Bypass] = "FALSE")) + COUNTROWS(FILTER(ALL('UPS (2)'), 'UPS (2)'[Redundant UPS] = "TRUE" && 'UPS (2)'[Redundant UPS Maintenance Bypass] = "TRUE")) + COUNTROWS(FILTER(ALL('UPS (2)'), 'UPS (2)'[Redundant UPS] = "TRUE" && 'UPS (2)'[Redundant UPS Maintenance Bypass] = "FALSE"))
VAR NoMaintBypass    = COUNTROWS(FILTER(ALL('UPS (2)'), 'UPS (2)'[UPS Maintenance Bypass] = "FALSE")) + COUNTROWS(FILTER(ALL('UPS (2)'), 'UPS (2)'[Redundant UPS] = "TRUE" && 'UPS (2)'[Redundant UPS Maintenance Bypass] = "FALSE"))
RETURN
DIVIDE(NoMaintBypass, TotalMaintBypass, 0) * 100 +0

same as above:
UPS %No Maint Bypass = 
VAR TotalMaintBypass = 
    COUNTROWS(
        FILTER(
            ALL('UPS (2)'), 
            'UPS (2)'[UPS Maintenance Bypass] = "TRUE"
        )
    ) +
    COUNTROWS(
        FILTER(
            ALL('UPS (2)'), 
            'UPS (2)'[UPS Maintenance Bypass] = "FALSE"
        )
    ) +
    COUNTROWS(
        FILTER(
            ALL('UPS (2)'), 
            'UPS (2)'[Redundant UPS] = "TRUE" &&
            'UPS (2)'[Redundant UPS Maintenance Bypass] = "TRUE"
        )
    ) +
    COUNTROWS(
        FILTER(
            ALL('UPS (2)'), 
            'UPS (2)'[Redundant UPS] = "TRUE" &&
            'UPS (2)'[Redundant UPS Maintenance Bypass] = "FALSE"
        )
    )

VAR NoMaintBypass = 
    COUNTROWS(
        FILTER(
            ALL('UPS (2)'), 
            'UPS (2)'[UPS Maintenance Bypass] = "FALSE"
        )
    ) +
    COUNTROWS(
        FILTER(
            ALL('UPS (2)'), 
            'UPS (2)'[Redundant UPS] = "TRUE" &&
            'UPS (2)'[Redundant UPS Maintenance Bypass] = "FALSE"
        )
    )

RETURN 
    DIVIDE(NoMaintBypass, TotalMaintBypass, 0) * 100 +0

As it’s currently written, your answer is unclear. Please edit to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

adding if statement in a Measure DAX

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related