Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Help with DAX code to filter group by a condition

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's avatar
    wdx223_Daniel
    3 years ago

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

1 Reply

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Icon for Community Champion rankCommunity Champion
    3 years ago

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