Count only Code A and B if it is same in any ID

[Anonymous]

Hi Team,

I am trying to count only Code  A & B if it same in any ID , any thoughts 

ID	Code
1002	A
1002	B
1002	C
1003	A
1003	D
1003	C
1004	A
1004	B
1005	A
1005	C
1005	D

id	A	B	C	D
1002	1	1	1
1003	1		1	1
1004	1	1
1005	1		1	1

Result will be 2 as a count , A & B  for 1002 & 1004 as per criteria

[ValtteriN · Accepted solution]

Hi,

I am not sure I fully understood, but try something like this:

Count A/B =

IF(

COUNTROWS(

    FILTER(

        'Table (7)','Table (7)'[Code]="A" || 'Table (7)'[Code]="B"))>1,1,0)

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[Anonymous · Accepted solution]

Hello

Please try this measure

Mesure =

var idrech=SELECTEDVALUE(Feuil3[ID ])

var step_1=filter(SUMMARIZE(Feuil3,Feuil3[ID ],Feuil3[Code]),Feuil3[Code] in {"A","B"})

var result =countrows(step_1)

return

if (result>1, result)

[Anonymous]

Thanks it working correctly.

[ValtteriN · Accepted solution]

Hi,

I am not sure I fully understood, but try something like this:

Count A/B =

IF(

COUNTROWS(

    FILTER(

        'Table (7)','Table (7)'[Code]="A" || 'Table (7)'[Code]="B"))>1,1,0)

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[Anonymous]

Amazing approach , Could you please add 1 more thing how can display 1 ( which are matching) by DAX in same Measures