Forum Discussion
Table to show blank values when using sum
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 enabl...
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
Try to right click on the Visual Field and check "Show Missing data".
That option goes away when using "Sum" unfortunately.
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.
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.