Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DistinctCount Names by ID

1 Mike 1 Mike 2 Eli 3 Paul 3 Mike 3 Stephen   I am trying to distinct count names (using a measure) by the ID. If an ID has the same name, I only need it counted once...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Create a measure like

     

    countrows(summarize(Table, Table[ID], Table[Name]) )

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , Create a measure like

 

countrows(summarize(Table, Table[ID], Table[Name]) )