Average Calculation

Hey,

the problem you are facing is the following:

You can't access measures from calculated columns, measures are created "on top" of an existing data model and for this reason are able to reflect user interaction. Calculated Columns are one part that "form" the data model.

For this reaon you may have to consider the following, use a measure to create the bin (the bucket the employee belongs to) or create an unrelated table that contains the various elements.

I guess you need to create some sample data, upload the pbix file to onedrive or dropbox and share the link.

Regards

Tom