Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Converting Calculated Column to Measure

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
Need Help
Show and Tell
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    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] )
    )
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
AlexisOlson
Super User
4 years ago

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] )
    )