Matrix showing only rows having values in every columns

Hi Zoko,

The correct check value for yellow company should not be marked as 0, because it has no value for "Cedante" role, right? 

In my above post, such a scenario returns expected check value. Not sure how your source dataset is, maybe you should post some dummy data here. By the way, are "Somme de REFID" and "Somme de BUID" original fields in dataset, or calculated measures or aggregated columns?

Besides, please try this measure to check if it works in your scenario.

check2 =
CALCULATE (
    IF ( SUM ( Test2[REF ID] ) = BLANK (), 1, 0 ),
    FILTER ( ALLEXCEPT ( Test2, Test2[Company] ), Test2[Role] = "Ced" )
)
    + CALCULATE (
        IF ( SUM ( Test2[BUID] ) = BLANK (), 1, 0 ),
        FILTER ( ALLEXCEPT ( Test2, Test2[Company] ), Test2[Role] = "Ced" )
    )
    + CALCULATE (
        IF ( SUM ( Test2[REF ID] ) = BLANK (), 1, 0 ),
        FILTER ( ALLEXCEPT ( Test2, Test2[Company] ), Test2[Role] = "Rea" )
    )
    + CALCULATE (
        IF ( SUM ( Test2[BUID] ) = BLANK (), 1, 0 ),
        FILTER ( ALLEXCEPT ( Test2, Test2[Company] ), Test2[Role] = "Rea" )
    )

Regards,

Yuliana Gu