Forum Discussion

Gr8apmech's avatar
Gr8apmech
Icon for Helper I rankHelper I
2 years ago
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 ...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

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

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Please explain the reasoning behind using ALLSELECTED.

 

Can you provide sample input data?

Gr8apmech's avatar
Gr8apmech
Icon for Helper I rankHelper I
2 years ago

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's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

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

    • Gr8apmech's avatar
      Gr8apmech
      Icon for Helper I rankHelper I
      2 years ago

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

       

      Thanks!