How to calculate a KPI FILTERED by a values from a table

[migueldfr_23]

Hello everyone, 

I am struggling with some issue.

I have a table with dates of PURCHASE ORDER, REQUESTED DATE and DELIVERY TIME.

I built:

- Requested delivery time

- Real delivery time

- Real vs Requested 

- Column = 1

NEXT STEPS : 
I want to create three more columns which is:

- sum( Real vs Requested ) , but this does not work, if I sum a master item (ONLY THE VALUES HAS BEEN MORE THAN 3 DAYS LATE) 

- Sum ( colunm 1) , this trigger on counting all the values we need to analyze (TOTAL) 

- DELAY : sum( Real vs Requested ) / sum(colunm 1) , is the aim of this calculation, percetage of delays, against total.