为BI提供Power BI多个条件

您可以尝试下面适用于度量和列的以下代码-

ok_not_ok = 

VAR item_count = 
CALCULATE(
    COUNT(your_table_2[item]),
    ALLEXCEPT(your_table_2,your_table_2[item])
)

VAR item_count_with_yp =
CALCULATE(
    COUNT(your_table_2[item]),
    FILTER(
        ALLEXCEPT(your_table_2,your_table_2[item]),
        RIGHT(your_table_2[code],3) = "-YP"            
    )
) + 0

RETURN IF(
    item_count_with_yp = 0 || item_count=item_count_with_yp, 
    "OK", 
    "NOT OK"
)

这是示例输出-