Set 99% as target date

[Ikezaki]

Hi everyone,

I have a table with the following dates "Ship by Date" "Shipped Date", I have create a column called Shipment Status with the following formula:

SHIPMENT_STATUS = if ('Export Worksheet'[SHIP_BY_DATE] <= 'Export Worksheet'[SHIPPED_DATE], "On Time", "Delayed")

Also I created a counter to see how many times the shipments are on time or delayed:

OCCURENCE =

COUNTX (

FILTER ( 'Export Worksheet', EARLIER ( 'Export Worksheet'[SHIPMENT_STATUS] ) = 'Export Worksheet'[SHIPMENT_STATUS] ),

'Export Worksheet'[SHIPMENT_STATUS])

I have to set a target where 99% of the shipments are on time. The report I am trying to build is a Table with the following information.

Department | Count of how many times the shipments are on time | The total of shipments (including on time+ delayed) | % of on time shipments

Thank you in advance.

[Ikezaki]

@PhilipTreacy  Hi Philip, 

Sorry for the late reply. I have solved this issue.

Thank you for the reply.

[v-robertq-msft]

Hi, @Ikezaki 

Glad to hear that you have solved the problem by yourself, would you like to share some experience or just mark your own reply as a solution?

Thanks in advance!

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PhilipTreacy]

Hi @Ikezaki 

Can you provide some sample data? Otherwise it has to be recreated rom nothing and that takes time and may not accurately reflect your real data.

regards

Phil