Count of Duplicates with Another Parameter

[pstp]

I have a table with ID's that signify people. There is another boolean column. I need a count of ID's that are duplicated in the table AND one of the rows with that ID has a TRUE value in the boolean column. Any suggestions on how to accomplish this?

[RanjeetK]

Hi @AlexisOlson 
what if that boolean Column is from another table ?????
i have try this but above solution is does not work 
it gives following error - 

anyone knows about this please help..................

Here is my Measure - Like Project is Table1 and Project Standard Accreditation is Table 2 

PQ count with virtual table 2 =
Var TableA =
SUMMARIZECOLUMNS (
Project[project ID],
'Project Standard Accreditation'[Project Std Acr Accreditation Id ],
'Project Standard Accreditation'[Project Std Acr Standard Id],
"Count Of Duplicates",
CALCULATE (
COUNT ( 'Project Standard Accreditation'[BK_NGPSBI_PROJECT_STANDARD_ACCREDITATION] ),
KEEPFILTERS ( 'Project Standard Accreditation'[Project Std Acr Active] = "Yes" ))
)
Var GreaterThan = FILTER(TableA,[Count Of Duplicates] >=2)
Var _Result = COUNTROWS(GreaterThan)
Return
_Result

[AlexisOlson · Accepted solution]

I think this might work:

Dupes =
VAR Summary =
    SUMMARIZE (
        Table1,
        Table1[ID],
        "@Count", COUNT ( Table1[ID] ),
        "@Bool", TRUE IN VALUES ( Table1[Boolean] )
    )
RETURN
    COUNTROWS ( FILTER ( Summary, [@Count] > 1 && [@Bool] ) )

[pstp]

This is excellent, thank you!