Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
This might be simple but need some help. I am trying to get a sum total of the column individual part cost x qty applied to ppm which should be a total of $2,543,433 but the total calculation shows $61815531900.79383, which is not what i want. Can anyone help me what i am doing wrong. Thanks
Solved! Go to Solution.
Hi @Anonymous ,
The individual part cost x qty applied to ppm is a calculated column or measure ?.
What is the output visual - Table or Matrix.
Please post your measures / cacluated column expressions to explore further.
Cheers
CheenuSing
Hi @Anonymous ,
The individual part cost x qty applied to ppm is a calculated column or measure ?.
What is the output visual - Table or Matrix.
Please post your measures / cacluated column expressions to explore further.
Cheers
CheenuSing
Hi ChenuSing
It is a Table
Hi @Anonymous ,
Remove the sum in your expression . It should be
INDIVIDUAL_PART_COST x QTY_APPLIED_TO_PPM = ('CQMS_MNC_DATA_V'[INDIVIDUAL_PART_COST]) * ('CQMS_MNC_DATA_V'[QTY_APPLIED_TO_PPM])
Check it out and let me know.
Cheers
CheenuSing
User | Count |
---|---|
93 | |
85 | |
77 | |
68 | |
62 |
User | Count |
---|---|
112 | |
97 | |
95 | |
64 | |
58 |