DAX function

[ppatil]

Hi Community..!!

date	name
16-May	ABC
16-May	XYZ
16-May	WOP
17-May	ABC
17-May	ABC
18-May	ABC
17-May	XYZ
17-May	XYZ
17-May	XYZ
17-May	ABC

expected output is :

name	count
ABC	3
XYZ	2
WOP	1

please refer the above images ,

name should be counted with respect to date.

ABC coming thrice in date 17-May then also it is counted as one.

will u please help me to do that?

waiting for quick response.

[NickolajJessen · Accepted solution]

[ppatil]

Thank U @NickolajJessen 

[Anonymous]

HI

Distinctcount(table[name])

[ppatil]

Hi @Anonymous 

It is not matching with expected output.

U can refer the expected output what I have mentioned.

[Anonymous]

Ppatil

Excuse me; Please find the code for the measure

testdistinct =

var namedistinct=SELECTEDVALUE(Disticnt[name])

var tabledisctinct=filter(SUMMARIZE(Disticnt,Disticnt[date],Disticnt[name]),Disticnt[name]=namedistinct)

var result = countrows(tabledisctinct)

return

result