Forum Discussion
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 ...
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() ) )
Check if this can work for you
calculate(avergae( Staff Efficency ), Staff Efficency <>0)
avergae(filter(table,Staff Efficency <>0)Staff Efficency )
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601