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.
Hi all
I am using this below formula
Current PC Contribution = DIVIDE(SUMX(Sheet1,IF(Sheet1[PC - 2]=Sheet1[max pc],Sheet1[Contrib val_3],0)),SUMX(Sheet1,IF(Sheet1[PC - 2]=Sheet1[max pc],Sheet1[Qty in Ton Adjusted],0)),0)
for values where contrib val 3 is -650 and qty in ton adjusted is 0 (replaced value from "-" to 0 in query editor) i am getting returned value as 29990370638585590000.00
when i put filters and try to get this single record value for the current pc contribution it shows 0 only, also the grand total is showing correct value.
I am displaying this value in a matrix column.
Solved! Go to Solution.
Just select the column [Qty in Ton Adjusted] and change the data type as shown below.
I can not reproduce the issue. Share us the .pbix file if convenient. Do mask sensitive data before uploading.
PBIX File:
https://drive.google.com/file/d/1CbhbmtplRSJxzu-CBVwMWe4zkHUuQj89/view?usp=sharing
the value for CSD is comming wrong, though the total is coming out correct.
The denominator is not exactly zero. A decimal number is always stored as a double-precision floating point value. You may change the data type of [Qty in Ton Adjusted] to fixed decimal number from the Modeling tab.
Tried modeling as well as rounding off not working.
It works for your .pbix above, please check again. As a kindly reminder, protect your privacy information.
Just select the column [Qty in Ton Adjusted] and change the data type as shown below.
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 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |