Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Service Level Issue - Days Not Showing Correct Result

Hello Power BI Community, I am facing an issue with a Power BI graph visual that involves service level calculations. Here's a brief overview of the problem: I have successfully calculated the ser...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

     

    You can create a measure.

     

    TotalLateDespatchs = COUNTROWS(FILTER('Despatch summary (7)','Despatch summary (7)'[IsLateDespatch] = 1))
    Flag = IF([ServiceLevel]=1,0,1)

     

    Then talk about [Flag=1] placed on the visual object filter.

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

 

Update measures.

TotalLateDespatchs = COUNTROWS(FILTER(ALLSELECTED('Despatch summary (7)'),'Despatch summary (7)'[IsLateDespatch] = 1))
TotalOrdersReleased = COUNTROWS(FILTER('Pick detail report (7)','Pick detail report (7)'[ReleasedAfterCutoff] = 0))

Then the result is as follows.

 

If the above one can't help you get the desired result, please provide your expected result with backend logic and special examples.

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous,
    Thanks for the answer! 

    I updated my measures as you described and I changed service level measure from: ServiceLevel = DIVIDE(([TotalOrdersReleased] - [TotalLateDespatchs]), [TotalOrdersReleased])

    To:
    ServiceLevel = 1-DIVIDE([TotalLateDespatchs],DISTINCTCOUNT('Pick detail report (7)'[Sales order number]))

    As I wanted to see the service level from the total orders released and not on the orders released after cut-off. 

    Allow me to describe the desired outcome. The graph shows six weeks, even though there should only be four. The total service level should be 99.58%, according to the card visual in the bottom left corner, but when I look at the graph, all of the weeks have less than 99%, which makes no sense to me.


    Then when I click on week 2 - it shows more than 13 days and it should only show day 8 to 14. 

    I have attached the new PBIX with the changes I have made: https://we.tl/t-SzDQFTlPuX

    I hope this clarifies my problems.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Anonymous ,

       

      You can create a measure.

       

      TotalLateDespatchs = COUNTROWS(FILTER('Despatch summary (7)','Despatch summary (7)'[IsLateDespatch] = 1))
      Flag = IF([ServiceLevel]=1,0,1)

       

      Then talk about [Flag=1] placed on the visual object filter.

      Best Regards,

      Neeko Tang

      If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.