Forum Discussion

dhanekula1996's avatar
dhanekula1996
Helper I
4 years ago
Solved

Reg: Switch function and Totals

Hello all,  I am trying to create a measure which shows values based on the condition. My code is working fine but my dax is not showing the total of the column. Can you please suggest me what chang...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    Is this what you're after?

    Relative Cost =
SUMX (
    VALUES ( 'Dimensions'[ECT Value] ),
    SWITCH (
        'Dimensions'[ECT Value],
        42, [Annual Cost  ($0.76)],
        51, [Annual Cost ($0.80)],
        48, [Annual Cost ($0.85)],
        61, [Annual Cost ($0.92)]
    )
)
AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

Is this what you're after?

Relative Cost =
SUMX (
    VALUES ( 'Dimensions'[ECT Value] ),
    SWITCH (
        'Dimensions'[ECT Value],
        42, [Annual Cost  ($0.76)],
        51, [Annual Cost ($0.80)],
        48, [Annual Cost ($0.85)],
        61, [Annual Cost ($0.92)]
    )
)