DAX Measure for Average per Branch

[_Regina]

_Average new accounts per Branch MTD =

var n= [New Accounts - MTD]   

var d = CALCULATE(DISTINCTCOUNT('Account LifeCycle'[BRANCH_DIM_SYSID]),FILTER('Account LifeCycle',[New Accounts - MTD]  >=1))

Return (n/d)

Hi Everyone,

I am trying to create a measure for new accounts per branch Month to date. I have a measure '[New Accounts - MTD]  ' which I am storing in var n.

For the denominator I am trying to capture the number of branches that have atleast one new account.  But the denominator (var d) is counting all the branches, the ones with no data as well. Hence giving me wrong average per branch.

I am unable to understand what I am doing wrong here.

I would appreciate any guidance here.

[wdx223_Daniel]

_Average new accounts per Branch MTD =

var n= [New Accounts - MTD]   

var d = CALCULATE(DISTINCTCOUNT('Account LifeCycle'[BRANCH_DIM_SYSID]),FILTER(ALL('Account LifeCycle'[BRANCH_DIM_SYSID]),[New Accounts - MTD]  >=1))

Return (n/d)