Calculate average in matrix visual

[Hems]

DatasetNeed to add another column AVG Employee Destination and AVG Employee Name

[TheoC · Accepted solution]

Hi @Hems 

You need to create a measure as follows and add this to your matrix:

Average ID per Emp Designation = 

Var _1 = COUNTROWS ('Table' )
VAR _2 = DISTINCTCOUNT ('Table'[Employee Designation] )

RETURN

DIVIDE ( _1 , _2 , 0 )

This will ensure that each Employee Designation calculates the IDs associated with each, but also provide you with the average in the column total.  Output like below:

PBIX file is attached. I hope this helps.

Theo 🙂

[Hems]

Thank you very much 🙂

[Hems]

DatasetNeed to add column calculate average of emp designation and avg emp name

[VahidDM]

Hi @Hems 

Can you post sample data as text and expected output?

please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
4. Relation between your tables

Appreciate your Kudos!!
LinkedIn:www.linkedin.com/in/vahid-dm/

[TheoC]

More than welcome @Hems 

All the best 🙂