Hi @kxaffke, I tried different options ifelse(countIf({Order#},isNull({Order#}))=0,1,0) and coalesce(count({Order#}), 0)
Source from another post
Also keep in mind that having a NULL value vs not having any data at all are two different things. A NULL value would be like having a row for Jan 1 2022, but the column value for Sales is empty. This is different than not having any rows for Jan 1 2022 at all. In the former scenario, you can replace the NULL with a 0 as some have pointed out on this thread (with an ifelse kind of calculation). In the latter scenario where there are no rows at all in the data, there is nothing to insersert a substitute into.
So, the work-around is to perform the count in your database / SQL and replace Null with 0 there.
I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!