pandas groupby column count distinct values
# Pandas group by a column looking at the count unique/count distinct values of another column
df.groupby('param')['group'].nunique()pandas groupby column count distinct values
# Pandas group by a column looking at the count unique/count distinct values of another column
df.groupby('param')['group'].nunique()select count distinct multiple columns sql server
SELECT COUNT(DISTINCT (CHECKSUM(DocumentId,DocumentSessionId)) + CHECKSUM(REVERSE(DocumentId),REVERSE(DocumentSessionId)) )
FROM DocumentOutPutItemsdax count distinct based on 2 columns
--Without filters
Measure1 = COUNTROWS(GROUPBY(User,User[FNAME],User[Card ID],User[Health ID],User[Gender]))
--With filters
Measure2 = COUNTROWS(FILTER(GROUPBY(User,User[FNAME],User[Card ID],User[Health ID],User[Gender]),User[Gender]="M"))Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
