Fill Rate Chart

[joobizz]

I calculated the percentage of deliveries made during the week by dividing what was delivered by what was requested. In this case it was 71.8% for the last week.

Delivered = 191
Requested = 266

191/266 = 71.8%

However, when I put these percentages in the reasons chart, the 71.8% is not being reflected in "Delivery Complete/Delivery Completed" and the percentage is being distributed to the other reasons.

Does anyone have any idea how I can fix this? I've tried using Calculate, AllExcepted, Filtered and nothing has worked.

I made the measures below, and the one I'm using in the graph to show the percentage is Reason_Requested-Delivered.

Delivered:
Reason_PODelivered = SUM(d_FillRate[Delivered])

Requested:
Reason_PORequested = SUM(d_FillRate[PORequested])
%:
Reason_Requested-Delivered = DIVIDE([Reason_PODelivered], [Reason_PORequested])

[amitchandak]

@joobizz m Based on what I got, you can try

% Reason_Requested-Delivered = calculate(DIVIDE([Reason_PODelivered], [Reason_PORequested]), removefilters(Table[Reason]) )

[joobizz]

Hi @amitchandak,

Thanks for you support.

I tested the suggestion, but the 71.8% is for all reasons, and 71.8% should only appear for Delivery Completed and the distribution of percentages in the other reasons.

Reason_Requested-Delivered = CALCULATE(

    DIVIDE([Reason_PODelivered], [Reason_PORequested]), REMOVEFILTERS(d_FillRate[Reasons]))