Forum Discussion

skoalit's avatar
skoalit
Regular Visitor
9 years ago

How Average () is calculated in Power BI

Hi,    Does anyone know if 'Null' values are included in the calculation of Average? And the best way to treat 'Null' and 'Blank' values, that when I do division or average, it will not show 'Infin...
Need Help
BhaveshPatel's avatar
BhaveshPatel
Super User
9 years ago

See this BLOG on how to handle blank values. You can create a measure for counting and summing rows that do not include blank using ISBLANK to except those rows that are blank.

skoalit's avatar
skoalit
Regular Visitor
9 years ago

Thanks! this is helpful! 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi skoalit，

    You should get detailed information about how Power BI handle blank values from the blog that BhaveshPatel provides.

    Thanks,
    Lydia Zhang

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Can someone help me with the average of person wise for four weeks data as mentioned below in the source file.

       

      If you see below screenshot i want average of four weeks with respect to employee name ... remember it has null values. Thanks