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)

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)