Count of values with more than 1 criteria

[simlee]

Hi all, 

I need help to count how many documents have more that one ID as per the below screenshot where the resutl show that only 2 documents have more than one ID.

Thank you

[amitchandak · Accepted solution]

@simlee , Try like

countx(filter(Summarize(table,table[document],table[IDs],"_1", count(Table[document])),[_1] >=2),[document])

[jthomson]

What happens if you try something like putting the document field into the rows of a matrix, then use a measure doing something like:

measure = if(countrows(IDs)=distinctcount(IDs),0,1)

[collinq]

hi @simlee ,

You just have to use Group By and count, like this:

One

Two

Three

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!