Forum Discussion

joobizz's avatar
joobizz
Regular Visitor
2 years ago

Fill Rate Chart

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 = 2...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
amitchandak's avatar
amitchandak
Super User
2 years ago

joobizz m Based on what I got, you can try

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

  • joobizz's avatar
    joobizz
    Regular Visitor
    2 years ago

    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]))