Help with DAX code to filter group by a condition

[Anonymous]

Hi Community,

I need help in developing a DAX code that looks ACCT_ID column and groups this column by unique ACCT_ID and then idenifies ACCT_ID's which only used BPAY as a payment type. 

[wdx223_Daniel · Accepted solution]

CalculatedColumn=IF(COUNTROWS(FILTER(Table,Table[ACCT_ID]=EARLIER(Table[ACCT_ID])&&able[PAYMENT TYPE]<>"BPAY"))=0,1)