topic Re: Help with DAX code to filter group by a condition in DAX Commands and Tips

Help with DAX code to filter group by a condition

Anonymous — Mon, 08 May 2023 03:30:34 GMT

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.

Re: Help with DAX code to filter group by a condition

wdx223_Daniel — Mon, 08 May 2023 04:23:19 GMT

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