How to calculate avg shipped day

[aAmirkHan]

Hi,

I have calculated total order 25K and also calcualtated avg shipped day 3.97 by using datediff DAX formula (difference between order date and shipped date). This is a calculated column of avg shipped day.

I want to calculate how many order are above avg shipped day and how many order are below shipped day and want to show in Donut visual. I am attaching a screen shot for the example.

I want to get the result as per this screen shot in my power bi report. Can you please help me how to do?

[wdx223_Daniel]

Below Avg. Time=VAR _avg=[Avg. Shpping Time] RETRUN COUNTROWS(FILTER(ALLSELECTED(Table[OrderID]),[Shipping Time]<_avg))

Above Avg. Time=COUNTROWS(ALLSELECTED(Table[OrderID]))-[Below Avg. Time]