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 change I need to do my code inorder to get Total of the column.
Greg_Deckler OpenDataLab ValtteriN amitchandak 
Dax Command:

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




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

2 Replies

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