Dax to return field value of one column present multiple times in another column

[Anonymous]

I was searching for a DAX to return true if ID column value of Table 2 is present multiple times in different Group(Table 1).

Table 1 :

Table 2 : 

I would like to create a "Check" DAX column to return ID value present in Table 1 multiple time for different Group 

[Anonymous · Accepted solution]

Hi @Anonymous ,

If you want to create a new table, try:

table = SUMMARIZE(Table1,Table1[ID],"ifmultiple",IF(CALCULATE(DISTINCTCOUNT(Table1[Group]),ALLEXCEPT(Table1,Table1[ID]))>1,"true","false"))

Best Regards,

Jay

[Samarth_18]

Hi @Anonymous 

Try this:-

Column =
CALCULATE (
    COUNTROWS ( __Table1 ),
    FILTER ( __Table1, __table1[ID] = EARLIER ( ___table2[ID] ) )
) > 1

Output:-

Thanks,

Samarth

[Anonymous]

Thanks for Replying, I was actually looking for grouping. As i have to check if the ID is present in different groups.