Forum Discussion
Solved
Calculate average in matrix visual
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 🙂
