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

[EMUDATA]

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. 

[EMUDATA]

@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. 

[Jihwan_Kim · Accepted solution]

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. 

[Jihwan_Kim]

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 )