Forum Discussion

MasterSonic's avatar
MasterSonic
Icon for Helper IV rankHelper IV
3 years ago
Solved

Count unique per other columns

Hello, Code Plan Status 101 Buy Ready 102 Sell Ready 102 Sell Ready I would like to count unique code by Status and Planm but I have duplicates in Code column. So on...
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    not sure if i get you, try this

    Measure2 = 

    COUNTROWS(
        SUMMARIZE(
            TableName, 
            TableName[Plan], 
            TableName[Code]
        )
    )
MasterSonic's avatar
MasterSonic
Icon for Helper IV rankHelper IV
3 years ago

Hi,
thanks but It does not give the wanted result.

lets extend my table

CodePlanStatus
101BuyReady
102SellReady
102SellReady
103SellReady


Now it should showing  col=Plan value=Sell  should be 2
As we have code duplicated.

I would like to count Code per Plan where value in column Status is Ready, but do not count duplicated Codes. Maybe this will help

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

not sure if i get you, try this

Measure2 = 

COUNTROWS(
    SUMMARIZE(
        TableName, 
        TableName[Plan], 
        TableName[Code]
    )
)
  • MasterSonic's avatar
    MasterSonic
    Icon for Helper IV rankHelper IV
    3 years ago

    Thank You for help I have added below and I got what wanted.

    Measure2 = 

    COUNTROWS(
        SUMMARIZE( FILTER( Table,Table[Status] = "Ready"),
            
            TableName[Plan], 
            TableName[Code]
        )
    )