topic Re: Count only Code A and B if it is same in any ID in DAX Commands and Tips

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

Anonymous — Tue, 23 Aug 2022 06:17:15 GMT

Hi Team,

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

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

ValtteriN — Tue, 23 Aug 2022 06:46:13 GMT

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 — Tue, 23 Aug 2022 06:48:36 GMT

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 — Wed, 24 Aug 2022 05:40:28 GMT

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

Anonymous — Wed, 24 Aug 2022 06:01:39 GMT

Thanks it working correctly.