DAX Measure for Average per Branch

_Regina — Mon, 23 Oct 2023 21:08:29 GMT

_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.

Re: DAX Measure for Average per Branch

wdx223_Daniel — Mon, 23 Oct 2023 23:55:59 GMT

_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)

topic Re: DAX Measure for Average per Branch in DAX Commands and Tips

DAX Measure for Average per Branch

Re: DAX Measure for Average per Branch