Help with DAX code that groups table on PER_ID and looks for PER_ID with one ACCT_ID

[EMUDATA]

@Community 

I am need help with a DAX code that groups groups PER_ID's in a table and looks for PER_IDs that have only one ACCT_ID attached.

Table below helps with explanation.

[EMUDATA]

@FreemanZ  WOW amazing work

[FreemanZ · Accepted solution]

hi @EMUDATA 

try like:

Column =

VAR _condition=

COUNTROWS(

     FILTER(

        data,

        data[PER_ID]=EARLIER(data[PER_ID])

    )

)

RETURN

IF(_condition=1, 1)