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. 

     

     

amitchandak's avatar
amitchandak
Super User
2 years ago

Anonymous , I Hope TotalOrdersReleased, TotalLateDespatches are measures. Try with this change

 

TotalOrdersReleased = CALCULATE(COUNTROWS('Pick detail report (7)'),Filter( 'Pick detail report (7)' 'Pick detail report (7)'[ReleasedAfterCutoff] = 0))

 

TotalLateDespatches = CALCULATE(COUNTROWS('Despatch summary (7)'), Filter('Despatch summary (7)', 'Despatch summary (7)'[IsLateDespatch] = 1) )

 

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

I recently discovered that I can send you a PBIX file using WeTransfer, so here's the link: https://we.tl/t-9v0iIOeYvL