How to calculate Supplier wise status count

[robleek100]

Hi Team,

Please help me in calculating the status based on the supplier id. If Any supplier id is expired then it shouldn't be counted as  active status.

I have highlighted few supplier id 102 where it has both status active and expired. If any supplier is expired then it shouldnt't be counted as Active. Then I should get the count for that supplier as expired only.

Moreover If any supplier is having only active status then it should be counted as Active. Every supplier is should have only single status either active or expired. But if any supplier is havign two status then it should be counted as "Expired" only.

Help needed...!

Thanks,

Rob

How to colculate Supplier wise status count

[v-chuncz-msft · Accepted solution]

@robleek100,

You may add the following calculated column.

Column =
IF (
    CONTAINS (
        Table1,
        Table1[Supplier ID], Table1[Supplier ID],
        Table1[Status], "Expired"
    ),
    "Expired",
    "Active"
)