Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

DAX optimisation row-wise calculation

Hello guys, need some help.   I have to calculate listed employee number - its average employee number. I have calculated two measures: Employee count = VAR total = CALCULATE( DISTINCT...
DAX
employee
optimize
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Anonymous try this:

 

Listed employee = AVERAGEX(VALUES('Calendar'[Year]),Employee[Employee count])
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks, parry2k , for support, but I need this measure to be dynamic.

It should calculate for Year, Month or Day.