Convert Calculated Column to Measure

Question

HelloI was wondering if its possible to convert this Calcuated column to a measure.. i did try to use Max but the values were wrong.&nbsp;Surplus Transaction (USD) = VAR usd =&nbsp; &nbsp; IF (&nbsp; &nbsp; &nbsp; &nbsp; au_cryptopayments[au_providedreference] = "V2"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || au_cryptopayments[au_providedreference] = "V2 - GSB-Direct",&nbsp; &nbsp; &nbsp; &nbsp; au_cryptopayments[FiatAmountUSD_v2],&nbsp; &nbsp; &nbsp; &nbsp; IF (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; au_cryptopayments[au_transactiontype] = "Deposit",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; au_cryptopayments[FiatAmountUSD_v2],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; au_cryptopayments[au_address] = "OTC Transaction",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; au_cryptopayments[au_actualfxtargetamount],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; au_cryptopayments[FiatAmount_USD]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; )RETURN&nbsp; &nbsp; IF (&nbsp; &nbsp; &nbsp; &nbsp; OR (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; au_cryptopayments[au_transactiontype] = "Sell",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; au_cryptopayments[au_transactiontype] = "Deposit"&nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; usd,&nbsp; &nbsp; IF (&nbsp; &nbsp; &nbsp; &nbsp; OR (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; au_cryptopayments[au_transactiontype] = "Resub",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; au_cryptopayments[au_transactiontype] = "Subscription"&nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; usd, BLANK() &nbsp; &nbsp; &nbsp; ))&nbsp;ThanksViral

amitchandak · Answer

viralpatel21 , You can move the code inside maxx, but I doubt that can help&nbsp; you 
&nbsp;
maxx(au_cryptopayments, &lt;Your code&gt;)

anonymous · Answer

Hi&nbsp;viralpatel21&nbsp;
&nbsp;
Are the fields in a visual, maybe you can use selectedvalue() function:
SELECTEDVALUE function - DAX | Microsoft Learn
&nbsp;
Best Regards,
Yolo Zhu
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

Forum Discussion

Convert Calculated Column to Measure

2 Replies

Related content

Convert calculated column into measure

DAX Calculated Measure

Convert measure to column

Measure converted to Calculated column shows different result

Converting calculated column into parameter