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...
Hi Anonymous ,
By my tests, we could use ISBLANK function in direct query mode.
We could use ISBLANK function to filter the value is null and then calculate the average.
If you still need help, please share some data sample and your desired output so that we could help further on it.
Best Regards,
Cherry
Hello v-piga-msft ,
When I tried to use the ISBLANK(), the result is empty. That's why we had to apply the filter to ignore the 0s in the data. In our case, it seems like Power BI is considering nulls as zeros which is not right. I will try to prepare the test data smaple for you if needed.
Thanks,