It would be appreciable if you share the TWBX file which contains your sample ( mock - data ).
It will help us to directly work closely on your dataset and get your problem sort out.
Hence, Please provide us with Tableau Workbook . So we can see how the data is and where the problem persists.
You can try below logic:
zn(lookup(sum([Is Crtitical]), 0))
zn is a row level calculation - so if you have a row in your datasource (not view) that has a measure with no entry (null), then zn will change that to 0.However, it would seem that you have no rows in the datasource that match that breakdown with dimension, so there's no row for zn to operate on. The table calculation option above should work.
Hi Meenu Choudhary,
This calculation field is to replace blank space with 0.
Thanks for your feedback, and yes, the problem is to replace blank with zero (What i need is to show Critical incident as 0 instead of an empty field.)
And "ZN" function used in the above mentioned way will replace blank with zero.
Please let me know if my understanding of your point is clear or not.
I think I had misunderstanding as whole page was not rendering earlier.
You are right and also this calculation will work.
It will solve this issue.