Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |