Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Service level display in graph

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 service level and created a graph visual that displays the weeks of January. The initial results are correct. However, when I click on the weeks, the days do not show the right result. 
I've created two columns:

ReleasedAfterCutoff = IF(TIME(HOUR('Pick detail report (7)'[Action created at (time)]), MINUTE('Pick detail report (7)'[Action created at (time)]), SECOND('Pick detail report (7)'[Action created at (time)])) < TIME(16, 15, 0), 1, 0)

IsLateDespatch = IF(TIME(HOUR('Despatch summary (7)'[Despatch date (time)]), MINUTE('Despatch summary (7)'[Despatch date (time)]), SECOND('Despatch summary (7)'[Despatch date (time)])) > TIME(16, 30, 0), 1, 0)

 

And the measures I'm using:

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

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

 

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. 

Here is the relationship I have between the tables:

Thank you in advance!

1 Reply