Counting only duplicates when condition is TRUE

[fever003]

Hi all, 

Hope to get some help here. I have a situation where I only want to count the UniqueID that has duplicates. Right now it is giving me 6 counts where as I expect to get only 4 accounts when selecting only Apple and Banana. 

DataTable

UniqueID	Attribute	Value
31464	Grapes	FALSE
31464	Apple	TRUE
31766	Apple	TRUE
31464	Coconut	TRUE
31471	Apple	FALSE
31471	Grapes	FALSE
31471	Banana	FALSE
31471	Coconut	FALSE
36033	Apple	TRUE
31766	Coconut	FALSE
36390	Apple	TRUE
31766	Grapes	FALSE
31464	Banana	TRUE
32420	Apple	FALSE
32420	Grapes	FALSE
32420	Coconut	FALSE
32624	Grapes	FALSE
32624	Apple	FALSE
32624	Banana	FALSE
32624	Coconut	FALSE
35764	Apple	FALSE
35764	Grapes	TRUE
31766	Banana	TRUE
35764	Coconut	TRUE
32420	Banana	TRUE
36033	Grapes	TRUE
35764	Banana	TRUE
36033	Coconut	FALSE
36033	Banana	TRUE
36390	Banana	TRUE
36390	Grapes	FALSE
36390	Coconut	FALSE

Expected result when choosing Apple and Banana only, with True. 

UniqueID	Attribute	Value
31464	Apple	TRUE
31464	Banana	TRUE
31766	Apple	TRUE
31766	Banana	TRUE
36033	Apple	TRUE
36033	Banana	TRUE
36390	Apple	TRUE
36390	Banana	TRUE
32420	Banana	TRUE
35764	Banana	TRUE

Hope to get some help, thanks.

[mahoneypat]

Here is another similar way to do it.

IDs with Duplicates =
COUNTROWS (
    FILTER (
        DISTINCT ( UniqueDuplicates[UniqueID] ),
        CALCULATE (
            COUNTROWS ( UniqueDuplicates ) = 2
        )
    )
)

Regards,

Pat

[fever003]

Thanks, this works too! 

[DataInsights · Accepted solution]

@fever003,

Try this measure:

Count UniqueID Duplicates = 
SUMX (
    --iterate the distinct UniqueIDs in the filter context
    VALUES ( DuplicateCount[UniqueID] ),
    --current UniqueID
    VAR vUniqueID = DuplicateCount[UniqueID]
    --return the rows for the current UniqueID in the filter context
    VAR vUniqueIDRows = FILTER ( ALLSELECTED ( DuplicateCount ), DuplicateCount[UniqueID] = vUniqueID )
    --if the current UniqueID has more than one row, assign a count of 1
    VAR vUniqueIDCount = IF ( COUNTROWS ( vUniqueIDRows ) > 1, 1 )
    RETURN
        vUniqueIDCount
)

[fever003]

Thank you! This is the solution I needed because it works with Filter context and I can add many other slicers to it. You're the best!