Robert Cain continues a series on KQL:
In the previous post of this series, Fun With KQL – DCount, we saw how to use the
dcountfunction to get an estimated count of rows for an incoming dataset.It’s common though to want to filter out certain rows from the count. While you could do the filtering before getting to the
dcount, there’s an alternative function that allows you to do the filtering right within it:dcountif.
Read on to learn more about how this function works, as well as several useful examples.