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

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

2 Replies

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