Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
Solved! Go to Solution.
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)]
)
)
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)]
)
)