Rolling Avg Period to Period without non trading day

[corange]

Hi everyone, 

Can someone help with my formula. 

I am trying to calculate a daily rolling average / period (month divided into two) and which will exlude non-trading days. 

The following formula works but I want the daily average wihch is based on the number of trading days in each period For each day, I have got a column using 1 / 0 if it is a trading / non trading day. 

My formula is like that at the moment but I dont know how to go about removing non trading days: 

Value rolling average = (SUM(SummaryBI[Value]) / CALCULATE(DISTINCTCOUNT('Calendar'[Period]),

DATESINPERIOD('Calendar'[Date],

LASTDATE('Calendar'[Period]),-3,MONTH), FILTER('Calendar', 'Calendar'[TradingDay]=1)))

I am thinking of changing CALCULATE(DISTINCTCOUNT('Calendar'[Period]) to CALCULATE(DISTINCTCOUNT('Calendar'[Date]). 

Can someone help me work on the formula a bit so it only includes trading days in my rolling average? 

Thank you. 

[amitchandak · Accepted solution]

@corange 

In your have the trading date 

Trading Date = if('Calendar'[TradingDay]=1,Calendar'[Period]), blank())

Now use distinctcount of trading Date. Power bi may count blank as one additional so reduce it from the distinct count