Forum Discussion
Solved
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 ...
In this scenario, yes - it's what causing all the numbers to be the same.
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]))*1000000