measure to count dulicates

[AI14]

Hi

i want to count the total finished however there areID's that are duplicate. how do i count filter and only dount unique values of another?

i have a measure with the following formula:

= countx(filter(Table,Table[Status]="Finished"),Table[Status])

example: 

ID	Status
A12	FINISHED
C67	FINISHED
D54	STARTED
C12	FINISHED
A12	FINISHED

[tamerj1 · Accepted solution]

Hi @AI14 

please try

=
CALCULATE ( DISTINCTCOUNT ( Table[ID] ), Table[Status] = "Finished" )

[AI14 · Accepted solution]

Thanks, worked.

what if i wanted to add 2 filters

i tried the below but didnt count, just showed blank

CALCULATE ( DISTINCTCOUNT ( Table[ID] ), Table[Status] = "Finished"  && Table[Status] = "Started" )

[tamerj1 · Accepted solution]

Hi @AI14 

please try

=
CALCULATE ( DISTINCTCOUNT ( Table[ID] ), Table[Status] = "Finished" )

[AI14 · Accepted solution]

Thanks, worked.

what if i wanted to add 2 filters

i tried the below but didnt count, just showed blank

CALCULATE ( DISTINCTCOUNT ( Table[ID] ), Table[Status] = "Finished"  && Table[Status] = "Started" )

[FreemanZ · Accepted solution]

try replacing && with ||

[FreemanZ]

hi @AI14 

try to create a measure like this:

count = 

VAR _table =

ADDCOLUMNS(

    VALUES(TableName[ID]),

   "Status",

   CALCULATE(MAX(TableName[Status]))

)

RETURN

COUNTROWS(

    FILTER(_table, TableName[Status] = "Finished")

)