Lookupvalue Measure

[bhelou]

Hello, i have this in a calculated column and working perfect , i need to convert it to a measure 

the search in my report is the transaction number : TRX_Num , i need to see the pay status for each single line in a measure not in columns for performance .

Formula :

Pay_Status =

IF (

ISBLANK (

LOOKUPVALUE (

AWPT_AR_CASH_RECEIPTS_LINES[TRX_NUMBER],

AWPT_AR_CASH_RECEIPTS_LINES[TRX_NUMBER], AWPT_AR_TRANSACTIONS_LINES[TRX_NUMBER]

)

),

"Not Paid",

"Paid"

)

Thank you very much 

[PhilipTreacy · Accepted solution]

Hi @bhelou 

Please provide your PBIX file or data.

Regards

Phil

[v-deddai1-msft · Accepted solution]

Hi @bhelou ,

You can use the following measure:

Pay_Status =
IF (
    ISBLANK (
        LOOKUPVALUE (
            AWPT_AR_CASH_RECEIPTS_LINES[TRX_NUMBER],
            AWPT_AR_CASH_RECEIPTS_LINES[TRX_NUMBER], MAX ( AWPT_AR_TRANSACTIONS_LINES[TRX_NUMBER] )
        )
    ),
    "Not Paid",
    "Paid"
)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[bhelou]

Thanksss , working great

[PhilipTreacy · Accepted solution]

Hi @bhelou 

Please provide your PBIX file or data.

Regards

Phil

[negi007]

@bhelou can you please share your data in text format and the structure of the data. we will then advise you accordinlgy

[bhelou]

Thank you very much , i solved it ,