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 Wrap your column references in an aggregation like MAX or SUM, etc.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Greg,

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