Measure for Minimum Weekly Average

[Anonymous]

I am trying to calculate the Minimum of a measure I have "Average Loading Time." Essentially, each week I look at the Average from the previous week but I would like to see the record minimum over the course of the data set. The error I am getting is because the data set has a few null loading times signifying we didn't pick up from them which we want to see also. 

So I need my Measure to calculate the minimum of AVG_LOADING while also ignoring the null values. 

I have tried two combos of this

Minimum Loading 2 =

CALCULATE(

FILTER('Orders','Orders'[AVG_LOADING]>1),

Min([AVG_LOADING]),

ALL('CALENDAR'[REPORT_DATE]))

Minimum Loading 2=

CALCULATE(

average(min('Orders'[Loading_time])),

ALL('CALENDAR'[REPORT_DATE]))

[Anonymous]

So the filters are set up on the page to view week_end_date. So Average Loading will pull 

[amitchandak]

@Anonymous , I do see any week code here

refer if my blog or video can help

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8