Convert Calculated Column to Measure

[viralpatel21]

Hello

I was wondering if its possible to convert this Calcuated column to a measure.. i did try to use Max but the values were wrong.

Surplus Transaction (USD) =

VAR usd =

    IF (

        au_cryptopayments[au_providedreference] = "V2"

            || au_cryptopayments[au_providedreference] = "V2 - GSB-Direct",

        au_cryptopayments[FiatAmountUSD_v2],

        IF (

            au_cryptopayments[au_transactiontype] = "Deposit",

            au_cryptopayments[FiatAmountUSD_v2],

            IF (

                au_cryptopayments[au_address] = "OTC Transaction",

                au_cryptopayments[au_actualfxtargetamount],

                au_cryptopayments[FiatAmount_USD]

            )

        )

    )

RETURN

    IF (

        OR (

            au_cryptopayments[au_transactiontype] = "Sell",

            au_cryptopayments[au_transactiontype] = "Deposit"

        ),

        usd,

    IF (

        OR (

            au_cryptopayments[au_transactiontype] = "Resub",

            au_cryptopayments[au_transactiontype] = "Subscription"

        ),

        usd, BLANK()  

    ))

Thanks

Viral

[v-xinruzhu-msft]

Hi @viralpatel21 

Are the fields in a visual, maybe you can use selectedvalue() function:

SELECTEDVALUE function - DAX | Microsoft Learn

^{Best Regards,}

^{Yolo Zhu}

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

[amitchandak]

@viralpatel21 , You can move the code inside maxx, but I doubt that can help  you

maxx(au_cryptopayments, <Your code>)