Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
christinek
Frequent Visitor

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

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?

 

NameDate 1Date 2Date 3
staff180%68%75%
staff270%82%80%
staff372%71%73%
etc   
3 REPLIES 3
v-heq-msft
Community Support
Community Support

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

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

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 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors