Dynamically update Pie Chart with data from a direct query based on a time slicer

Hi Anonymous ,

If the donut visual should show the distinct number of pumps for each status, we can try to use the following measures:

PumpNumber = 
SWITCH (
    SELECTEDVALUE ( LegandTable[LegandName] ),
    "Red", SUMX (
        'Pump Number',
        IF (
            CALCULATE (
                COUNTROWS ( RELATEDTABLE ( 'Pump' ) ),
                'Pump'[Active / Not Active] = 0
            ) > 0
                && CALCULATE (
                    MAX ( 'Pump'[Active / Not Active] ),
                    FILTER ( RELATEDTABLE ( 'Pump' ), 'Pump'[Date] = [Today] - 1 )
                ) = 1,
            1,
            BLANK ()
        )
    ),
    "Green", SUMX (
        'Pump Number',
        IF (
            CALCULATE (
                COUNTROWS ( RELATEDTABLE ( 'Pump' ) ),
                'Pump'[Active / Not Active] = 1
            )
                = CALCULATE ( COUNTROWS ( RELATEDTABLE ( 'Pump' ) ) ),
            1,
            BLANK ()
        )
    ),
    "Yellow", SUMX (
        'Pump Number',
        IF (
            CALCULATE (
                MAX ( 'Pump'[Active / Not Active] ),
                FILTER ( RELATEDTABLE ( 'Pump' ), 'Pump'[Date] = [Today] - 1 )
            ) = 0,
            1,
            BLANK ()
        )
    )
)

Best regards,