custom column, with the line average

Matheus_Giam , Looking at this data you better unpivot

https://radacad.com/pivot-and-unpivot-with-power-bi

Pivot using Matrix and have a Sun total Avg at the client using allexcept

https://www.sqlbi.com/articles/managing-all-functions-in-dax-all-allselected-allnoblankrow-allexcept/

https://community.powerbi.com/t5/Desktop/Percentage-of-subtotal/td-p/95390

hi  Matheus_Giam 

Use this formula to add a custom column in power query:

List.Sum({[jan],[fev],[mar],[abr]})/

( (if [jan] = null or [jan] = 0  then 0 else 1)+
    (if [fev] = null or [fev] = 0  then 0 else 1)+
     (if [mar] = null or [mar] = 0  then 0 else 1)+
      (if [abr] = null or [abr] = 0  then 0 else 1)
)

Result:

and here is sample pbix file, please try it.

Regards,

Lin