topic Re: measure to count dulicates in DAX Commands and Tips

measure to count dulicates

AI14 — Sat, 21 Jan 2023 09:58:30 GMT

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:

FreemanZ — Sat, 21 Jan 2023 10:07:36 GMT

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

)

tamerj1 — Sat, 21 Jan 2023 10:08:11 GMT

please try

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

AI14 — Sat, 21 Jan 2023 10:22:29 GMT

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 — Sat, 21 Jan 2023 10:45:36 GMT

try replacing && with ||