distinctcount id depending on values

Hi yellowold5 ,

I think maybe you can try these steps below:

I create a table as you mentioned.

Then I think you can create a new table and here is my DAX code.

NewTable =
ADDCOLUMNS (
    SUMMARIZE ( 'Table', 'Table'[ID], 'Table'[productid], 'Table'[desciption] ),
    "A",
        IF (
            CALCULATE (
                COUNTROWS ( 'Table' ),
                ALLEXCEPT ( 'Table', 'Table'[ID] ),
                'Table'[desciption] = "frozen"
            )
                = CALCULATE ( COUNTROWS ( 'Table' ), ALLEXCEPT ( 'Table', 'Table'[ID] ) ),
            1,
            BLANK ()
        ),
    "B",
        IF (
            CALCULATE (
                COUNTROWS ( 'Table' ),
                ALLEXCEPT ( 'Table', 'Table'[ID] ),
                'Table'[desciption] = "fresh"
            )
                = CALCULATE ( COUNTROWS ( 'Table' ), ALLEXCEPT ( 'Table', 'Table'[ID] ) ),
            1,
            BLANK ()
        ),
    "C",
        IF (
            CALCULATE (
                COUNTROWS ( 'Table' ),
                ALLEXCEPT ( 'Table', 'Table'[ID] ),
                'Table'[desciption] = "frozen"
            ) > 0
                && CALCULATE (
                    COUNTROWS ( 'Table' ),
                    ALLEXCEPT ( 'Table', 'Table'[ID] ),
                    'Table'[desciption] = "fresh"
                ) > 0,
            1,
            BLANK ()
        )
)

 Finally you will get what you want.

Best Regards

Yilong Zhou

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