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()
            )
    )

     

     

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
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()
            )
    )