Show Average of figures in table which are based on a measure I added

[christinek]

Hi Power BI Community.

I created a measure called productivity % to display the percentages in a table like this below.

I now wish to have a column to show in this table the average of the 3 percentages for these 3 dates (or however many dates I choose to show), but I am having alot of trouble as I am new to Power BI.

I tried to use the AVERAGE or AVERAGEX but my productivity % measure is not available (parameter incorrect).

I also tried to total my productivity % first, but again my productivity % measure is not available.

How can I caluate the average please?

Name	Date 1	Date 2	Date 3
staff1	80%	68%	75%
staff2	70%	82%	80%
staff3	72%	71%	73%
etc

[v-heq-msft]

Hi @christinek ,

In Power BI, you cannot directly calculate the average of a measure. However, you can create a new measure that calculates the average based on the underlying data.

In order to go about solving your problem, I need more accurate data such as Employee Production Per Day values, Employee Production Per Day Ratio Measurement Tables and measure you create.

Please refer to the official Power BI documentation for more details on AVERAGEX function.

AVERAGEX function (DAX) - DAX | Microsoft Learn

In order for you to solve the problem faster, you can refer to the following documentation

How to Get Your Question Answered Quickly - Microsoft Fabric Community

Best Regards,
Albert He

[christinek]

Thanks Albert.  I will refer to the documentation and give it a go myself now that I understand the basics a bit more.

[v-heq-msft]

Hi @christinek ,

If my method successfully solves your problem during your testing, that’s great! If not, feel free to continue the discussion. I’m here to assist further if needed.

In order for you to solve the problem faster, you can refer to the following documentation

How to Get Your Question Answered Quickly - Microsoft Fabric Community

Best Regards,

Albert He