1 of 1 people found this helpful
Create a calculation like below
zn(lookup(table calculated measure,0))
Hope this helps
In order to capture the Table calculation --> Drag the measure to text --> right click on the measure --> Select Table calculation --> Drag that table calculation with holding control --> Place it in measures --> a new field will be created (with naming as calculation ) --> rename it --> use this calculation.
Plz mark this answer as correct or helpful to close the thread
Thanks for the pointers.
I've created the new calculated field with a slight modification (ZN(LOOKUP(SUM([Mbr Count]),0))) and now I have zeros where I previously had blank fields.
For the last point I am a little stuck. I've dragged the new calculated field to text but when I right click I am not presented with the option to select table calculation, I have the following options available to me:
Do you mean to edit the table calculation? If so then I have the following options available
already its a table calculation just you need to edit it how you want the addressing and partition
Yes I have the table with 0's now but I can not run a quick table calculation on the "Test" measure.
How can I save this table as a new calculated field?