Forum Discussion

steambucky's avatar
steambucky
Icon for Helper III rankHelper III
7 years ago
Solved

Getting averages from SPECIFIC rows

Units of a department are getting evaluated on 4 things.  Anywhere there is a 0 means that unit is not yet evaluated. I need to create averages from units that HAVE been evaluated.  This is the ...
Need Help
  • edhans's avatar
    edhans
    7 years ago

    You can use AVERAGEX and replace the zeros with blanks in the measure without changing your underlying data. Blanks are not evaluated with the AVERAGEX function.

     

     

     

    Manager Training Avg = 
    AVERAGEX('DataTable',
        IF(
            'DataTable'[Manager Training] > 0,
            'DataTable'[Manager Training],
            BLANK()
            )
    )

     

     

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
7 years ago

Hi steambucky ,
Please try this 

Mgr EfficiencyAverage no zeros = CALCULATE(AVERAGE(NR[Manager Efficency ]),NR[Manager Efficency ]<>0)



Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel