Calculating daily values for Defects per Unit (DPU), getting monthly data now...

[Gr8apmech]

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...

1 DPU = Calculate(

2    (DIVIDE([Defects],('Delivery'[LNs Issued]))*1000000)+0,

3    Allselected('Date'[Date]))

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

[Gr8apmech]

results!  thanks!!!

[lbendlin]

Please explain the reasoning behind using ALLSELECTED.

Can you provide sample input data?

[Gr8apmech]

@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

[lbendlin · Accepted solution]

In this scenario, yes - it's what causing all the numbers to be the same.

[Gr8apmech]

I found that i also had the ALLSELECTED on my 'Defects' formula...removed that and BOOM it works!

Thanks!