Calculated measure for average

We currently have a csv that we need to report on. How do i create a calculated measure that will give me the average. here is how the data looks in the file:

this is what we are trying to achieve:


For creating the report you describe you must have one more column of “1”. This column is the record counter; we need to have such a measure for implementing the counts by specific values of the BU and Env columns.

The data mapping could be the following:

After the data import you can use the “Env” dimension for showing averages and counts and create the average calculation with the custom formula:

Your report could look like this:

Janis, eazyBI support

Thanks this helps :slight_smile: