Table to show blank values when using sum

[Anonymous]

I have a table with columns/values from a few different tables, one of which is a sum of a value. 

I want this value to show when blank, but I can't seem to enable that option when "Sum of" is enabled. 

Is there any way around this? 

Thanks 

What happens now is I should see X number of projects in my table, but because some of them have a blank value here, I get less than expected rows/projects. I still want to see all of my rows even if this value is blank. 

[Anonymous]

Hi @Anonymous ,

Assume there are Type and Value columns in the table.

So for Value column, please select "Sum" ; And for Type column, select "Don't summarize" and "Show items with no data", as shown below:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Thanks for the reply, 

For some reason this didn't yield the expected results, 

I ended up doing a simple measure that solved the issue:

blank = sum(table[value])+0

[Anonymous]

Hello, I think by doing this, it gives a number, but in my case it always return 0 for the list with empty value.

[Anonymous]

Try to right click on the Visual Field and check "Show Missing data".

[Anonymous]

That option goes away when using  "Sum" unfortunately. 

[Anonymous]

Sorry, what is the "Sum of" column? is it a measure or a calculated column?

Also the option is "Show item with no data" - should be visible for ProjectName and not for the Measure in the visual.

[Anonymous]

Sum - when you have values you can choose to have sum, average, min, max etc. or "Don't summarize", and it's only when it is on "Don't summarize" I can select "Show item with no data". 

It's not a measure, just a regular decimal number column. 

[Anonymous]

Exactly, Why would you summarize the Project Name in your visual? Maybe I m missing something. Can you share what columns are you showing in the Matrix/Table?

If you do not summarize Project Name, then you can rightclick in the Fields visual and select "show item with no data".

[Anonymous]

I never said I wanted to sum the names, must be a missunderstanding, sorry if I was unclear somewhere. 

Like I've said, if I don't select Sum I can see the "show item with no data", but I need to sum the values, and then the option disappears.