Forum Discussion

Williamwil88's avatar
Williamwil88
Frequent Visitor
9 years ago
Solved

Formula Error

I am attempting to calculate a value called _QPPM using two different sources. The value is derived from the number of identified failure divided by the number of shipments for the month multiplied b...
Need Help
  • parry2k's avatar
    parry2k
    9 years ago

    if possible, can you put sample data form both tables in a excel sheet and send it over, i will put together somethign quickly and share pbix file wiht you, it will be much easier.

     

    I don't see there is any dedicated calendar table and that seems to be first missing part in all this. 

parry2k's avatar
parry2k
Super User
9 years ago

if possible, can you put sample data form both tables in a excel sheet and send it over, i will put together somethign quickly and share pbix file wiht you, it will be much easier.

 

I don't see there is any dedicated calendar table and that seems to be first missing part in all this. 

Williamwil88's avatar
Williamwil88
Frequent Visitor
9 years ago

It looks like you are correct. I needed the dedicated calendar; however, the sum value for RejectQty is incorrect. For example, using my data the number of failures for the month of September 2016 should be 363.  The number of failures shown is 97.

 

The calculation used is as follows:

_RejectQty = SUM(NCMR[Initial Qty Reject])

 

My visualization of the data: