Converting Calculated Column to Measure

[Anonymous]

Hi Experts,

Below is the DAX for Calculated Column, I would like to convert the same as DAX Measure. Can anyone Help me Please!!!

Thank you

[Greg_Deckler]

@Anonymous If you post it as text, sure.

[Anonymous]

Hi Greg,

AUMBAND =
VAR CurrentPortfolio = 'Financial Overview'[Portfolio]
VAR CurrentFinPort =
FILTER('Financial Overview','Financial Overview'[Portfolio] = CurrentPortfolio)

Return
IF('Financial Overview'[FinOverFinLevel1] = "Assets Under Management",
SUMX(CurrentFinPort,'Financial Overview'[Balance]))

[AlexisOlson · Accepted solution]

I'd probably rewrite it something like this:

AUMBAND =
VAR CurrentPortfolio =
    VALUES ( 'Financial Overview'[Portfolio] )
VAR CurrentFinPort =
    FILTER (
        'Financial Overview',
        'Financial Overview'[Portfolio] IN CurrentPortfolio
    )
RETURN
    IF (
        SELECTEDVALUE ( 'Financial Overview'[FinOverFinLevel1] ) = "Assets Under Management",
        SUMX ( CurrentFinPort, 'Financial Overview'[Balance] )
    )

[Greg_Deckler]

@Anonymous Wrap your column references in an aggregation like MAX or SUM, etc.

[Anonymous]

Hi Greg,

Thank you for your quick reply. Could I trouble to convert it as a measure, Please!!