I have used Number of Records () field as my only measure. But, it shows blank if there is null. I want show zero (). How to do that ? Looks like, ZN () function doesn't work.
This is a sample:
Have you tried : ZN(LOOKUP(SUM([Number of Records]),0))
Also, check this article that has a lot of reference to this issue: Force Blanks to Show.
Retrieving data ...