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]
        )
    )
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]
    )
)