Forum Discussion
Calculating daily values for Defects per Unit (DPU), getting monthly data now...
I'm looking to get to a daily DPU in my measures, currently they only result in monthly. Some days there are zero(0) defects so I added the '+0' to see a number but i believe it may be affecting my division/formula below? I am using a calendar table as my date and have set up my relationship to my receipt date.
This formula results the same if i remove the Calculate/Allselected portion...
Current Result/Table:
| Date | DPU |
| 7/1/2024 0:00 | 18226.002430133656 |
| 7/2/2024 0:00 | 18226.002430133656 |
| 7/3/2024 0:00 | 18226.002430133656 |
| 7/4/2024 0:00 | 18226.002430133656 |
| 7/5/2024 0:00 | 18226.002430133656 |
| 7/6/2024 0:00 | 18226.002430133656 |
| 7/7/2024 0:00 | 18226.002430133656 |
| 7/8/2024 0:00 | 18226.002430133656 |
| 7/9/2024 0:00 | 18226.002430133656 |
| 7/10/2024 0:00 | 18226.002430133656 |
| 7/11/2024 0:00 | 18226.002430133656 |
| 7/12/2024 0:00 | 18226.002430133656 |
| 7/13/2024 0:00 | 18226.002430133656 |
What i'd like to achieve:
| Date | DPU |
| 7/1/2024 | 3560.01234 |
| 7/2/2024 | 29751.01234 |
| 7/3/2024 | 2134.10234 |
| 7/4/2024 | 5110.1110 |
| 7/5/2024 | 1820.9874 |
In this scenario, yes - it's what causing all the numbers to be the same.
5 Replies
Please explain the reasoning behind using ALLSELECTED.
Can you provide sample input data?
lbendlin There really is no reason other than i was trying to use the filter to be able to select a few days of the month and determine the DPU for that period of time. Allselected was used to filter with...is that the wrong method to use?
This formula provides the same results:
DPU = DIVIDE([Defects],('Delivery'[LNs Issued]))*1000000In this scenario, yes - it's what causing all the numbers to be the same.
results! thanks!!!
