measure delivery on time in variable time zone

[Anonymous]

I want to measure the quote for the delivery on time and for each customer. The borders, when a delivery is on time, are variable.

For example: All deliveries, who 3 days too early and 1 day too late, are ok. 

Can someone help me with the problem?

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

My idea is to define 2 variables. but i don´t know how I should do it. 

Here one step of my idea: 

delivery loyalty quote =

Var delivery_loyalty = CALCULATE(COUNTROWS('orders'),FILTER('orders',AND('orders'[days of delay]>= Lower_boundary, 'orders'[days of delay] <= Upper_boundary)))

return

delivery_loyalty / [no. of orders]

[Anonymous · Accepted solution]

@amitchandak I have found a solution for this problem. 

[amitchandak]

@Anonymous , Kudos to you. If possible, can share some more information on how you solved it using the above model.

[Anonymous]

How to Get Your Question Answered Quickly (powerbi.com)