Forum Discussion
Nulls in Power BI in Direct Query mode
Hi All, I observed that Power BI included the count of Nulls when calculating the averages. What's more surprising is that, Power BI considers Nulls as 0 which is not correct first of all and thi...
Levajar
Advocate II
Advocate IIDid you try below link ?
https://docs.microsoft.com/en-us/dax/isblank-function-dax
It has an example for one scenario :
=IF( SUM(InternetSales_USD[SalesAmount_USD])= 0 , BLANK() , SUM(ResellerSales_USD[SalesAmount_USD])/SUM(InternetSales_USD[SalesAmount_USD]) )
Hi Levajar
We do not have any blanks in our data, only few nulls and since I mentioned before Power Bi was considering these nulls as zeroes we had incrrect averages.
Thanks