Forum Discussion

Hems's avatar
Hems
Frequent Visitor
4 years ago
Solved

Calculate average in matrix visual

Need Help
  • TheoC's avatar
    TheoC
    4 years ago

    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's avatar
Hems
Frequent Visitor
4 years ago

Thank you very much 🙂

Hems's avatar
Hems
Frequent Visitor
4 years ago

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