Help with ISBLANK function

Hi, medwards 

You can try the following methods.

Sample data:

Measure:

# Tables with no person assigned = 
CALCULATE ( DISTINCTCOUNT ( responsibility[table_id] ),
        FILTER ( ALL ( responsibility ),
            responsibility[role_id] = "Engineer"
                && ISBLANK ( responsibility[user_id] )
        )
    )

Or

Measure = 
CALCULATE ( DISTINCTCOUNT ( responsibility[table_id] ),
        FILTER ( ALL ( responsibility ),
            responsibility[role_id] = "Engineer"
                &&  responsibility[user_id] = BLANK()
        )
    )

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

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