Distinct Count with exceptions

Hi Anonymous 

Link to download the file: https://gofile.io/d/cVkADd

Try this code to add a column to your Client table:

Result = 
VAR _Count =
    COUNTROWS (
        CALCULATETABLE (
            EXCEPT (
                VALUES ( Client[Client_ID] ),
                SUMMARIZE (
                    FILTER (
                        'Status Change',
                        'Status Change'[Status_ID] = 5
                            || 'Status Change'[Current_Status_ID] = 5
                    ),
                    Client[Client_ID]
                )
            ),
            ALLEXCEPT ( Client, Client[Client_ID] )
        )
    )
RETURN
    IF ( ISBLANK ( _Count ), 0, _Count )

Output:

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Appreciate your Kudos  !!