Could you please attach the .twbx workbook so that i can look on the issue.
You may try with this,
zn(lookup(COUNTD([Your field]), 0))
You can also follow this kb article
Else share some sample mock up data in packaged workbook.
Unfortunately, both suggestions not working,
here's an update, the issue is not in SUM some NULL values, then ZN will not work, and all suggestions I went through assume that I'm trying to do this,
but, the real issue is that I'm trying to count "0 marks",
now any ideas ??
COUNTD() ignores the NULL values in the calculation thus it will not be counted.
You don't need to share your original workbook. Create a sample data which matches with your original and connect it in tableau then share.
I'm not trying to COUNT NULL values,
I'm trying to count "0 marks" and this gives me BLANK, I need it to give me 0 instead,
and I already attached a sample data and wb,
The filters are on Status and Country doesn't exist in the data, so the query that Tableau is issuing to the data source is returning 0 rows. So Tableau isn't even drawing a mark.
This thread has the the only solution of your scenario.
so, this method works if and only if I put some dimensions in rows and columns, but in my specific case, no solution valid, because I'll not use any dimension in neither rows nor columns, special thanks for you all