topic Re: Help with DAX code that groups by ACCT_ID and looks for Payment Type in DAX Commands and Tips

Help with DAX code that groups by ACCT_ID and looks for Payment Type

Anonymous — Sun, 30 Apr 2023 01:23:30 GMT

Hi Community,

I need help with a DAX code that looks up a table groups the ACCT_ID and only indicates where payments on the account are either AUSTPOST or BPAY. Insert below helps explain the output required.

Re: Help with DAX code that groups by ACCT_ID and looks for Payment Type

Jihwan_Kim — Sun, 30 Apr 2023 05:23:31 GMT

Hi,

Please check the below picture and the attached pbix file.

It is for creating a new column.

Result required CC = VAR _conditionone = { "BPAY" } IN SUMMARIZE ( FILTER ( Data, Data[Acc_ID] = EARLIER ( Data[Acc_ID] ) ), Data[Payment Type] ) VAR _conditiontwo = { "AustPost" } IN SUMMARIZE ( FILTER ( Data, Data[Acc_ID] = EARLIER ( Data[Acc_ID] ) ), Data[Payment Type] ) VAR _conditionthree = ( _conditionone || _conditiontwo ) && COUNTROWS ( FILTER ( Data, Data[Acc_ID] = EARLIER ( Data[Acc_ID] ) && Data[Payment Type] <> "BPAY" && Data[Payment Type] <> "AustPost" ) ) = 0 RETURN DIVIDE ( _conditionthree, _conditionthree )

Re: Help with DAX code that groups by ACCT_ID and looks for Payment Type

Anonymous — Sun, 30 Apr 2023 05:43:58 GMT

jwint Thank you I am receiving and issue with the code below. Are you able to help? It must have something do to with the relationship between the two tables. The TND_SOURCE_CODE is stored in a seperate table to ACCT_ID.

Re: Help with DAX code that groups by ACCT_ID and looks for Payment Type

Jihwan_Kim — Sun, 30 Apr 2023 10:46:40 GMT

Hi,

Thank you for your message.

Could you please share your sample pbix file's link?

Are you looking for the calculated measure or calculated column?

Thanks.