Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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)]
)
)
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |