OTIF Calculate for Logistics

It worked now.

1) I didn't notice that the measures should be under the Customer table. I put and voilà.

2) I did some adjustments to some formulas to work properly in the Matrix visual. Thanks for the help v-zhangti .

IF%

IF% = DIVIDE(
CALCULATE(COUNT(fact_orders_aggregate[order_id]),
FILTER(fact_orders_aggregate,[in_full]=1)),[Total_Orders]
)

The colour of the background change depending on target vs performance.

Color_IF = 
var V=DIVIDE(dim_customers[IF%],dim_targets_orders[IF_Target%])
return IF(V>=1,"#FFFFFF",
            if(V>0.7,"#01B8AA",
                IF(V>0.3&&V<0.7,"#F2C80F",
                    IF(V>0,"#FD625E"))))

Now, the next headache is doing like the drawing below. By periods.

I'm trying but the values don't spread through the period properly.