Order fulfillment rate trend chart measure wont work

[Rob83]

Hi Guys,

I have a problem with my order fulfillment rate. I can build a chart which show you the order fulfillment rate of a specific month but I can’t show a trend line over couple of months for orders that are planned within the same week (order fulfillment in weeks "0") as the customer requested. When I try this I get an order fulfillment rate of 100% for each month.

Here you can find a sample of my report:

https://drive.google.com/file/d/0B-aKxQAljmzwVlRsUDNtRXN2NEk/view?usp=sharing

In this report you find two charts. The one on the right is the one I can’t get working.

% of total – This calculate the order fulfillment rate in %

% of Total = DIVIDE([Quantity];[Total qty])

Total Qty – This calculate the total Quantity of a period selected

Total qty = calculate(sum('Order fulfillment rate'[Qty]); ALLSELECTED('Order fulfillment rate'[Order intake & On time fulfillment in weeks]))

The black line in the right chart should be:

Jan 45.18%

Feb. 39.34%

Mar 54.54%

Apr 77.76%

I think it has something to do with the calculation of Total Qty because it calculates different depending on the filters you use. That’s good because it hat to change when a new month is selected but for the right chart I have only selected the orders with a planned receipt date within a week of the requested date. I guess the total Qty calculates in this case only the orders on time and not all the orders of the month. Somebody knows how to fix this?

[v-ljerr-msft · Accepted solution]

Hi @Rob83,

Based on my test with your shared sample pbix file, you should be able to use the formula below to create a new measure, and then show it on the right chart. 

% of Total 2 =
DIVIDE (
    CALCULATE (
        [Quantity],
        'Order fullfilment rate'[Order intake & On time fulfillment in weeks] = 0
    ),
    [Quantity]
)

Note: You need to remove the "order fulfillment in weeks is "0"" visual level filter from the right chart.

Here is the modified pbix file for your reference. 

Regards

[Rob83]

That's fast! thanks it works great!