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.
Hello,
I've seen that this is a relatively common issue but I was having trouble translating other's solutions to my scenario. Each day has different amounts of blocked stock, clear stock and total stock quantity so I used the WEEKNUM function to help totalize these values for each week. Problem is when I used a quick measure for First Pass Quality (= Clear Stock/Total Stock) I get 100% instead of 99.72%.
Thanks in advance for the help!
Solved! Go to Solution.
@walla386 , Check the data type and number of decimal places under the column/measure tool.
Also better to use divide([Clear Stock],[Total Stock])
or
divide([Clear Stock]*1.0,[Total Stock])
@walla386 , Check the data type and number of decimal places under the column/measure tool.
Also better to use divide([Clear Stock],[Total Stock])
or
divide([Clear Stock]*1.0,[Total Stock])
I feel quite silly for not catching that myself, thank you for the help!
@walla386
Can you share the real formula?
Have you applied the correct formatting to the measure? with Percentage with 2 decimals?
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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 |