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] )
    )
Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

Anonymous If you post it as text, sure.

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